Spreadsheet Tips

How to Use Absolute Value in Excel

November 10, 2018
How to Use Absolute Value in Excel

The "Absolute Value" function in Excel: =ABS()

"Absolute value" is a math function that flips the sign on a negative number but changes nothing about a positive number. For example, the absolute value of both -4 and 4 is 4.

This comes in handy in several situations. For example, some features of travel are always positive regardless of the "direction" of travel, like the amount of fuel spent. Another example is fees (like exchange fees or transaction fees), which are often positive regardless of the direction of transfer.