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!
Thanks.


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

Hi

If I understand you right:


A1 has value 8976 for exmple

B1 has 46% of first 250
=if(A1>250,250*.46,A1*.46)

C1 has 50% of >250 and <3500
=if(A1>250,A1>3500,.50*3250,.50*(A1-250),0)

D1 has 44% of >3500
=if(A1>3500,.44*(A1-3500),0


This should work

Jacob

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

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