Thread: Multiple ifs
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default Multiple ifs
Please try this one: if I interpreted your post and formula correctly,
this should do it for you.
=IF(B22=0,0,IF(C22="x",B22*80*1.5,MAX(B22*80,18.75 )))

Reply With QuoteReply With Quote