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
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.
Search JabSto ::

Custom Search