Excel Guides

Using the ABS Function in Excel

The ABS function in Excel returns the absolute value of a number. The absolute value of a number is the number without its sign. For example, the absolute value of -5 is 5, and the absolute value of 5 is also 5.

You can use the ABS function in Excel to make sure that numbers are always positive. This can be useful when you're working with data that could have both positive and negative values, and you want to make sure that all values are positive.

To use the ABS function, you'll need to enter it into a cell in your spreadsheet. In the cell, you'll need to enter the following:


Replace "number" with the cell reference or value that you want to get the absolute value for.

For example, if you wanted to get the absolute value for the number in cell A1, you would enter the following into another cell:


Move beyond 


Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.