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 ...

This tutorial shows you how to fix and remove #DIV/0! error in Microsoft Excel by using the IFERROR or ISERROR function.