Read Excel Tips Such As How To Use Natural Language Formulas To Refer To The Current Row At BrightHub.com
Bright Hub » Office Productivity » Home Office Tech
» Articles » Microsoft Excel: Use Natural Language Formulas To Refer To The Current Row
RSS
 View all Hubs
See what's in...

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

Article by Mr Excel (11,376 pts )
Published on Jun 24, 2008
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.
21 views

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

Fig. 221Fig. 222

Channel Tags

View all »

Recent Articles...

Recent Reviews...

Recent Blogs...

Bright Hub - Science & Technology Articles, Buyer's Guides, How-To Tips and Software Reviews
Become Bright Hub Writer
About Bright Hub | Contact Us | Terms of Use | Privacy Policy | Copyright Policy | ©2008 Bright Hub Inc. All rights reserved. Page copy protected against web site content infringement by Copyscape