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

"David Biddulph" wrote:

I think you meant
=IF(A124,B1*0.9,IF(A10,B1*0.7,""))
or perhaps
=IF(A129,"",IF(A124,B1*0.9,IF(A10,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.
--
David Biddulph

"FSt1" wrote in message
...
hi
try this...
=IF(A124,A1*0.9,IF(A10,A1*0.7,""))


regards
FSt1

"NeSchw6G" wrote:

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