Multiple ifs and formulas

[NeSchw6G]

I need help building a formula for this:
if cell A1 is between 0-24 then multiply cell B1 by .07 and if cell A1 is
between 25-29 then mulitply cell B1 by .09

Thank you

 

[FSt1]

hi
try this...
=IF(A1>24,A1*0.9,IF(A1>0,A1*0.7,""))


regards
FSt1

 

[David Biddulph]

I think you meant
=IF(A1>24,B1*0.9,IF(A1>0,B1*0.7,""))
or perhaps
=IF(A1>29,"",IF(A1>24,B1*0.9,IF(A1>0,B1*0.7,"")))

.... and the OP may wish to think about what result is required for A1 less
than zero, between 24 and 25, or beyond 29.
.... and also whether "between" is inclusive or not.

 

[NeSchw6G]

Okay that helps, but it's also a bit more complex because there are 11 tiers:
0-24 is .07
25-29 multiply by .09
30-34 multiply by .12
35-39 multiply by .13
40-44 multiply by .15
45-49 multiply by .22
50-54 multiply by .34
55-59 multiply by .63
60-64 multiply by .97
65-69 multiply by 1.87
70-99 multiply by 3.04

Is this still possible?

And the range includes the beginning and ending number. Cell A1 is always a
positive and is below 99.

Thank you!!!

 

[Peo Sjoblom]

Try this


=B1*VLOOKUP(A1,{0,0.07;25,0.09;30,0.12;35,0.13;40,0.15;45,0.22;50,0.34;55,0.63;60,0.97;65,1.87;70,3.04},2)

--


Regards,


Peo Sjoblom

 

[Peo Sjoblom]

I didn't even spot that

--


Regards,


Peo Sjoblom