This article describes the formula syntax and usage of the **ABS** function in Microsoft Excel.

**PurposeĀ **

Returns the absolute value of a number.

**Sample Usage**

`ABS(-2)`

`ABS(A2)`

**Syntax**

`ABS(value)`

`value`

– The number of which to return the absolute value.

**Examples**

A | B | |
---|---|---|

1 | Result |
Formula |

2 | 26 | =ABS(-26) |

3 | 3.68 | =ABS(-3.68) |

4 | 2 | =ABS(-6/3) |