Microsoft Office Tutorials and References
In Depth Information
BUILT-IN FUNCTIONS
FIGURE E-24
Ratio of height to time in column H
Assume that all runners whose height in inches is less than their time in minutes will get an award. How
many awards are needed? If the ratio is less than 1, an award is warranted. The COUNTIF function in cell
G18 computes a count of ratios less than 1, as shown in Figure E-25.
FIGURE E-25
COUNTIF function used in cell G18
 
Search JabSto ::




Custom Search