< Back

# ABS function

Post

This article describes the formula syntax and usage of the

The ABS function syntax has the following arguments:

You can also use a cell reference for this formula.

**ABS function**

This article describes the formula syntax and usage of the

**ABS**function in Microsoft Excel.

**Description**Returns the absolute value of a number. The absolute value of a number is the number without its sign.

**Syntax**ABS(number)

The ABS function syntax has the following arguments:

**Number**Required. The real number of which you want the absolute value; or the cell reference which contains the number

**Example**These are the results that you can expect from this formula. You can copy the Formula into excel and check the results.

Formula | Description | Result |

=ABS(2) | Absolute value of 2 | 2 |

=ABS(-2) | Absolute value of -2 | 2 |

**Example:**=ABS(A2) gives you the result for value in cell A2.