• Mathematical and Financial Functions
  • ABS Function
  • AVERAGE Function
  • CGROUP Function
  • CGROUPT Function
  • COLCOUNT Function
  • COUNTIF function
  • EXP Function
  • FV Function
  • LOG Function
  • Mathematical and Financial Functions
  • 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