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