Absolute value function

To use this function, choose Calc > Calculator.

Represents a value by its magnitude (size) alone, without considering its sign (negative or positive). The absolute value function changes all negative numbers to positive numbers. Positive numbers and zero are unchanged.

The notation | | is used to represent absolute value. For example, | -14 | equals 14.



For number, enter the number or column of numbers from which to calculate the absolute value.


Calculator expression Result
ABS (-23.5) 23.5
ABS (0.34) 0.34


The absolute value is useful for assessing the magnitude of values apart from their direction, such as:
  • The bias in a measurement system
  • Factor effects on a response
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy