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

 Tips & Tricks New Tips Added Weekly! Click here to get on our Mailing List

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
Click here to sign up for more FREE tips

 You may want to read these articles from the 599CD News:
 2/22/2022 ISO Date Format 1/27/2022 Work Days 1/11/2022 Excel Fast Tips 1/7/2022 Count Cells by Color 1/7/2022 Excel VBA 1/7/2022 Excel Count by Color 12/26/2021 Conditional Formatting 12/9/2021 Excel 2003 Quick Start 1 12/9/2021 Excel 2003 Expert 232 12/9/2021 Excel 2003 Expert 231

 Learn  Access - index Excel - index Word - index Windows - index PowerPoint - index Photoshop - index Visual Basic - index ASP - index Seminars More... Customers  Login My Account My Courses Lost Password Memberships Student Databases Change Email Info  Latest News New Releases User Forums Topic Glossary Tips & Tricks Search The Site Code Vault Collapse Menus Help  Customer Support Web Site Tour FAQs TechHelp Consulting Services About  Background Testimonials Jobs Affiliate Program Richard Rost Free Lessons Mailing List Order  Video Tutorials Handbooks Memberships Learning Connection Idiot's Guide to Excel Volume Discounts Payment Info Shipping Terms of Sale Contact  Contact Info Support Policy Email Richard Mailing Address Phone Number Fax Number Course Survey