ABS(X)

 

Description

This function returns the absolute (positive) value of its argument.

 

Parameters

 

X

A numeric value or cell reference containing a numeric value.

 

Examples

 

ABS(5) = 5

 

ABS(-5) = 5

 

ABS(52) = 52

 

ABS(C15) = 10

Where C15 = -10.

 

SQRT( ABS(D4) ) = 10

Where D4 = -100.