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
