Thread: AND IF formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jane Jane is offline
external usenet poster
  
Posts: 202
Default AND IF formula
I need a formula that if three conditions are met then the word "yes" is
entered. Have tried =IF(AND(J2<K2,L2.08,L2<.098),"yes",''") and this
doesn't work.
--
thank you
Reply With QuoteReply With Quote