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

 Home   Courses   Seminars   Templates   TechHelp   Fast Tips   Forums   Help   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

 Check out these other pages that may be of interest to you:
 2/3/2023 TextSplit 1/27/2023 Math in Fields 12/12/2022 Tax Brackets 12/9/2022 Double Lookup 10/24/2022 Follow Hyperlink 9/17/2022 Very Hidden 8/11/2022 Crosstab 8/10/2022 Transpose 7/26/2022 Lottery Numbers 2 7/22/2022 Lottery Numbers