## ABS Function

A lesser know function in Excel is ABS, which is short for absolute. This function simply converts any negative number into a positive one.

To use it we simply type in the function and refernce a cell which contains a number. If the number is positive then this number is displayed. If it is negative then the number gets converted into a positive number. If the result is not a number then we get an error. For example the number 7 remains as the number 7. Minus 7 gets made into a positive number 7 and entering text produces an error.