one way:

=IF(OR(A1<75000,A1=150000),"out of range",IF(A1<100000,0.3,0.8)*A1)


In article ,
"Jenny" wrote:

I want a formula that will calculate like this:

If the total in this cell is between 75,000 and 99,999 then muliply it by
.30. If it's between 100,000 and 149,999 then muliply it by .80. Is this
possible?