ABS

Returns the absolute value of a number — the number without its sign. Negative numbers become positive; positive numbers and zero are unchanged.

Examples

• ABS(-510) - Returns 510.
• ABS(A5) - Absolute value of the number in A5.
• ABS(revenue{country{“Germany”}, !2}) - Absolute value of the second-lowest revenue where country is Germany.