Thread: help with if,and,else statement
View Single Post
  #4   Report Post  
JE McGimpsey
 
Posts: n/a
Default
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))
Reply With QuoteReply With Quote