Microsoft Office Tutorials and References

In Depth Information

**Syntax**

Figure 11.24.

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.

Syntax

=ABS(number)

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.