Abs

The ABS formula returns the absolute value of the specified number.

Syntax Description
abs(number) The ABS formula returns the absolute value of the specified number.

abs(number)
The ABS function returns the absolute value of the specified number. For negative numbers, it returns a positive number; positive numbers and zero remain unchanged.
Syntax: abs(Number)
Name Description
Number type: number | The number for which the absolute value is to be calculated.
Returns Description
Number number
Examples:
=abs(-123)                                         //result: 123
=abs(12.53)                                        //result: 12.53
=abs(section1.A1)
=abs(A)
=abs(B3)
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk