Thread: formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bondi
 
Posts: n/a
Default formula
Hi,

Maybe you can use something like this in cell D5

=IF(B5<=99,1.5,IF(B5<=150,2,3))

Regards,
Bondi

Reply With QuoteReply With Quote