ABS

Purpose

  • Returns the absolute value of a number

Example

  • Observe as we use ABS to calculate the absolute value of a number (and then copy and paste the formula to multiple cells):

ABS

  • Here is a screenshot, for reference:

ABS

  • Notice that:
    • ABS only works with numbers (and though not shown, ABS will treat blank cells as 0)
    • A #VALUE! error is returned when ABS function references text

Syntax

  • =ABS(number)

Arguments

  • number
    • This is the number that you need the absolute value of
    • This can be a hard-coded number, cell reference, or calculation

External Links