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	State	Revenue	Capital	Statehood[B]

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

Population
(2013 est)[8]

2

4,833,722

52,420 (135,767)

7

3

735,132

665,384 (1,723,337)

1

4

6,626,624

113,990 (295,233)

9

5

2,959,373

53,179 (137,733)

4

6

38,332,521

163,695 (423,968)

53

7

5,268,367

104,094 (269,602)

7

8

9