MrExcel Publishing
Your One Stop for Excel Tips & Solutions

IF Statement

Posted by Penny on December 19, 2001 8:37 PM

I am looking for a way to create the following:
Cell A Cell B Cell C
8976 46 %of the first 250, 50% of 3500 less the first 250

Cell D
44% of everything over 3500.00

I did this with an IF statement, however am having problems when the number is less than the 3500 or the 250. I want the values in Cell C and D to be 0 if the number is <250 for Cell C and <3500 for Cell D. HELP!

Posted by Jacob on December 19, 2001 8:50 PM


If I understand you right:

A1 has value 8976 for exmple

B1 has 46% of first 250

C1 has 50% of >250 and <3500

D1 has 44% of >3500

This should work


Posted by Penny on December 19, 2001 8:59 PM

Thanks bunches!! That will do it. Appreciate the answer so quickly! :)