ABS

Returns the absolute value of a number. The absolute value of a number is the number without its sign.

Syntax

ABS(number)

Number   is the real number of which you want the absolute value.

Examples

ABS(2) equals 2

ABS(-2) equals 2

If A1 contains -16, then:

SQRT(ABS(A1)) equals 4

Offset

Name

Size

Contents

4

rw

2

Row

6

col

2

Column

8

ixfe

2

Index to the XF record

10

num

8

Floating-point number value