To make numbers show up without the negative or any other signs, you would use Excel’s ABS function. The ABS function will return the Absolute value of the number.

If you want to get the result of a negative value, you have to use the ABS function. The ABS function returns the absolute value of a number; it converts negative numbers to positive numbers ...

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.