ABS function The ABS function take a negative number, like -5, and returns it as a positive. It’s purpose is to find the absolute value of a number. = ABS(cell address or a negative number) ABS Calc image The C9 cell contains the ABS formula. It returns the number -5 in C8 as a positive. The formula also is available in Microsoft Excel Share this:TwitterFacebookLike this:Like Loading...