Thank you! I understand what you are doing now. Only one question though.
Shouldn't it be A1= 48? Rather than <= 48?

Dex

"JE McGimpsey" wrote in message
...
just a bit shorter:

=B1*IF(A1<36,0.7,IF(A1<=48,0.8,0.9))

In article ,
"JulieD" wrote:

=IF(A1<36,B1*0.7,IF(A1<=48,B1*0.8,B1*0.9))