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