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.
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<65,Dependants*4,0).
As you copy this formula down the column, Excel will properly calculate the formulas based on the age and dependents in the current row.
Summary: Again, natural language formulas allow non-technical people to write formulas in plain language.
