Excel 2010-2019 Excel 2007 Excel 2003 Tips & Tricks Excel Forum Course Index CIG Excel Book

 Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon More... What's New? Popular Links ------------ Access Courses Access Index Access TechHelp Access Forum Access Troubleshooter Access Developer Network Access AI Bot ------------ Excel Courses Excel Index ------------ Code Vault Testimonials Tip Jar Advice for Consultants

Complex IF Function Example
Use the IF function to solve a complex problem across multiple columns

Q: We are a chamber of commerce with a complicated dues structure. Can you help me figure out how to calculate dues based on the total number of employees using the following table?

 First 5 employees \$165 Total Next 5 add \$5 per employee Next 15 add \$4 per Next 20 add \$3 per Over 50 add \$2 per

A: Eric what you want to do is not necessarily difficult if you can break it up into multiple steps using the IF function and some basic math.

Here is a FREE video tutorial that shows you how to set up this spreadsheet step-by-step:

If you need a more basic understanding of how the IF function works, check out this tutorial.

By Richard Rost