Microsoft Office Tutorials and References
In Depth Information
ABS
ABS The ABS function returns the absolute value of a number—the number without its sign.
=ABS(number)
The ABS function always returns a positive number. The NUMBER argument can be a value, a
single-cell range, such as ABS(A1) , or a multiple-cell range, which returns an array of values.
An example of using ABS in a multiple-cell range is shown below.
This is the function you would use for looking at the absolute differences of a set of data from
a given value. As you see in Figure 10.1, ABS can be used to find the value from a data range
that is closest to the average of that data. This formula creates an array of absolute
differences, as calculated by the ABS function, between the data and the average of the data. This is
matched to the minimum difference, and the INDEX function returns the desired value based
on that match. The formula as shown in the figure is an array formula. To enter an array
formula, hold down Ctrl+Shift+Enter. Also notice less complex uses of the ABS function that
return the absolute value of a real number.
Is the real number you want to convert to an absolute.
NUMBER
Figure 10.1
The ABS function can
be used to create
arrays of absolute
differences to be used in
complex formulas.
ACO The ACOS function returns the arccosine of a number, in radians in the range 0 (zero) to pi.
The arccosine is the angle of which the cosine is number.
=ACOS(number)
The number is the cosine of the angle you want and it is restricted to the range of –1 to 1. As
with all normal trigonometric functions in Excel, you can convert the result from radians to
degrees by multiplying it by 180/PI().
Search JabSto ::

Custom Search