Microsoft Excel: Use Natural Language Formulas To Refer To The Current Row

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

Images