Thread: if statements help
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
flummi
 
Posts: n/a
Default if statements help
This is your formula as it should work:

=IF(D6*1.5<=$E$1,$E$1,IF(D6*1.5=$E$2,$E$2,D6*1.5) )

Hans

Reply With QuoteReply With Quote