ABS
Definition
Returns the absolute value of a number.
Sample Usage
Syntax
ABS(value)
value- The number of which to return the absolute value.
Notes
If value is nonnumeric, ABS returns the #VALUE! error value.
Step 1. To begin to use the ABS formula, start with the Excellentable you would like to edit.
Step 2 : Then type the ABS formula into the cell you have chosen to display the outcome:
Step 3 : Type in the complete ABS formula for a cell as shown below:
Step 4 : Excellentable will generate the outcome when hitting enter.
A
|
B
|
C
|
D
|
|
|---|---|---|---|---|
1
|
Total area in mi2(km2)[C][9]
House seat(s)
2
Alabama
169.65
Montgomery
/OADate(-29236)/
3
Alaska
169.64
Juneau
1/3/1959
4
Arizona
2.98
Phoenix
2/14/1912
5
Arkansas
-2.98
Little Rock
/OADate(-23208)/
6
California
150.3
Sacramento
/OADate(-18009)/
7
Colorado
150.25
Denver
/OADate(-8551)/
8
9
2.98
E
|
F
|
G
|
|
|---|---|---|---|
1
|
|||
2
|
|||
3
|
|||
4
|
|||
5
|
|||
6
|
|||
7
|
|||
8
|
|||
9
|