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

 Home   Courses   Seminars   Templates   Help   TechHelp   Forums   Contact   Join   Order   Logon More... What's New? Popular Links ------------ Access Courses Access Index Access TechHelp Access Forum ------------ Excel Courses Excel Index ------------ Code Vault Testimonials

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