# ABS function – How to get absolute value in excel

Contents

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:

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: