Microsoft Office Tutorials and References

In Depth Information

**COSH**

The
COS
function is useful for determining the lengths of sides and central angles of

geometric shapes, as shown in Figure 10.10. The degrees symbol was created with a custom number

format and can be accessed from the CD included with this topic.

The number is the angle in radians that you are looking for. If the

angle is in degrees, you can multiply it by 180/PI() to convert it to

radians.

NUMBER

Figure 10.10

The
COS
function

returns the cosine of a

given angle.

COS
The
COSH
function returns the hyperbolic cosine of a number.

=COSH(number)

NUMBER
Is the
NUMBER
argument of any real number for which you want to

find the hyperbolic cosine.

COSH(n)
is equivalent to
(EXP(n)+EXP(-n))/2
.

Example:
COSH(0.5)
equals
1.128
.

COUNTIF

The
COUNTIF
function counts the number of cells within a range that meet the given criteria.

=COUNTIF(range,criteria)

The
RANGE
argument is the range of cells from which you want to count cells. It is important

to note that this argument cannot be a calculated array, unlike many functions that do not

differentiate between a worksheet range and an array.