Excel Tip: Complex IF Function Example

News User Comments History Notify Me

3/30/2009 4:38:01 AM
Excel Tip: Complex IF Function Example
By Richard Rost

I just received another excellent Excel question that I posted a FREE video answer to. This person wanted to know how to take a very complex dues structure and create a spreadsheet to figure out membership dues based on the number of employees per member company. I solve the problem with a set of IF functions and some math. See for yourself:

/tips/excel/complex-if-example

Enjoy.

Permanent Link
Keywords: excel tips complex if function

Post Reply

Add Your Comments or Subscribe

If you just want to subscribe to get email updates when the News is updated, then enter your name and email address and check the Notify Me box below. If you would optionally like to add your comments below to be posted, they are welcome.
Your Name:	Required
Your Email:	NOT Public
Subject:
Comments:
	Sorry about this step. It's just to keep the spam bots away:
Verify:	What is 1+7:

	Notify me when the News is updated.
	Remember Me for my next comments


Please do not use this form for Customer Service inquiries! If you have questions about your account, shipping info, courses you've ordered, need passwords, etc. please use the Customer Service Center instead. I value your comments. They will be displayed on this page (above). Your name will be displayed, but your email address will not be. As always, I promise to never give away your personal information to anyone else, ever. NOTE: If you don't leave your name and email address, DON'T expect a reply. I can't promise a personal reply to everyone who posts here. I TRY my best, but I cannot guarantee it. If you don't leave your real name and email address, I won't even bother. I usually just hit DELETE. -Richard