Problem: In the previous example, a natural language formula referred specifically to one cell by indicating a row name and a column name. It is also possible to have natural language formulas that refer to a specific column in the current row.
See all Microsoft Excel tips
Strategy: As shown in Fig. 221, you have a census of employees and their benefit selections.
The company buys life insurance for anyone under the age of 65. The rate for life insurance is $4 per dependant. As shown in Fig. 222, you can write a natural language formula in E2: =IF(Age
Summary: Again, natural language formulas allow non-technical people to write formulas in plain language.
See all Microsoft Excel tips