This blog explains how to get absolute value in Excel using the **ABS function** with syntax and examples.

## How to get absolute value in Excel?

The Microsoft Excel ABS function returns the absolute value of a number.

What is an absolute value?

The absolute value represents its value without its sign.

For example:

Value | Absolute Value |
---|---|

-1 | 1 |

+1 | 1 |

0 | 0 |

The ABS function is a built-in *Math/Trig Function in Excel*. It can be used as a worksheet function (WS) and a VBA function (VBA) in Excel. As a worksheet function, the ABS function can be entered as part of a formula in a cell of a worksheet. As a VBA function, you can use this function in that is entered through the Microsoft Visual Basic Editor.

Syntax

The syntax for the ABS function in Microsoft Excel is:

ABS( number )

### Parameters or Arguments

number – A numeric value used to calculate the absolute value.

Returns

The ABS function returns a numeric value.

### Applies To

- Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000

### Type of Function

- Worksheet function (WS)
- VBA function (VBA)

### Example (as Worksheet Function)

Let’s look at some Excel ABS function examples and explore how to use the ABS function as a worksheet function in Microsoft Excel:

ABS Function

Original Value | ABS Function (Original Value) | Formula |

-1 | 1 | =ABS(A2) |

0 | 0 | =ABS(A3) |

1 | 1 | =ABS(A4) |