Tuesday, February 17, 2009

The ABS function in Excel


The ABS Function In excel
If you need to determine the absolute value of a number, you use the ABS function. It returns the positive equivalent of any value referenced. Thus, if you wanted the absolute value of the sum of cell A1 and cell A2, you would use the following format:

{ =abs(sum(A1:A2)) }

No comments:

Post a Comment