Try
=IF(A15<100000,A15*0.15,IF(A15<250000,A15*0.12,A15 *0.1))

"Krista" wrote:

I need to create a formula for the following:

If A1=any number from 0 to 100,000 then A1*.15
If A1=any number from 101,000 to 250,000 then A1*.12
If A1=any number from 251,000 to 500,000 then A1*.10

Any suggestions?

Thanks much!
--
Krista