• Mathematical and Financial Functions
  • Mathematical and Financial Functions
  • ABS function
  • AVERAGE function
  • CGROUP function
  • CGROUPT function
  • COLCOUNT function
  • EXP function
  • FV function
  • LOG function
  • MAX function
  • MEDIAN function
  • MIN function
  • MKDEC function
  • MKINT function
  • MOD function
  • POS function
  • PV function
  • R function
  • RATIO function
  • RC function
  • RCNV function
  • RCR function
  • RCTOTAL function
  • ROUND function
  • ROWCOUNT function
  • RR function
  • RRTOTAL function
  • STDDEV function
  • SUM function
  • TOTAL function

ABS Function

The ABS function returns the absolute value of a number or numeric expression. The absolute value of a number is the number without its sign. The number must be an integer.

Syntax

ABS(number)

Number is the real number for which the absolute value is to be returned.

Example 1

ABS(4) equals 4

Example 2

ABS(-4) equals 4

Example 3

ABS(c10)

Returns the absolute value of cell number c10, and therefore, will always be positive.

Related Topics

• Mathematical and Financial Functions