This tip was printed from the Tips for Spreadsheets website at http://tipsforspreadsheets.com/.

Microsoft Excel 2003 Functions and Formulas - Return a Number Without the Negative Sign

When performing Microsoft Excel calculations there may be times where you need to return a number without its negative prefix (the absolute value of a number). For this you can use the =ABS function.

For example:

=ABS(25)
25

=ABS(-25)
25



Press the "print" button on your browser or select "File" - "Print" to print this tip. Then, return to Microsoft Excel 2003 Functions and Formulas - Return a Number Without the Negative Sign.
 
Standard disclaimer applies - Read http://tipsforspreadsheets.com/copyright-disclaim.html.