Microsoft Office Tutorials and References
In Depth Information
Figure 11.24. ABS
ABS measures the size of an error, ignoring the sign.
measures the size of an error, ignoring the sign.
The ABS function measures the size of the error. Positive errors are repor-
ted as positive, and negative errors are reported as positive as well. You
can use =ABS(A2-B2) to demonstrate that the other station ’ s forecaster is
off by 20 degrees on average.
The ABS function returns the absolute value of a number — that is, the num-
ber without its sign. With this function, the argument numberis the real num-
ber for which you want the absolute number.