Absolute Value

Automate Excel

Absolute Value

An easy one in Excel is absolute value, or change a negative number to positive. The function for absolute value is ABS()

To get the absolute value of a value in cell A1 enter the following in a blank cell:

=ABS(A1)

Posted in Formulas |

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.