Navigation:  Formula Reference > Spreadsheet Formula Functions > ABS

ApplyBI Documentation

ABS

This function calculates the absolute value of the specified value.

Syntax

ABS(value)

ABS(expression)

Arguments

This function can take either a value or an expression as an argument.

Remarks

This function turns negative values into positive values.

Data Types

Accepts numeric data. Returns numeric data.

Examples

ABS(R3C2)

ABS(B3)

ABS(-4) gives the result 4

ABS(14-24) gives the result 10

ABS(4) gives the result 4

 

See Also

SIGN

 

Copyright © Envision Ltd. All rights reserved.

Send comments on this topic.