Thread: IF statement formular
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
duane duane is offline
external usenet poster
  
Posts: 1
Default IF statement formular

assuming your cell references are correct

=IF(OR(C19<Criteria!H4,C8<Criteria!H11,C22<Criteri a!H18),"LLLLLL","")

would appear to return LLLLLL if any criteria not met, and "" if all
are


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=561904

Reply With QuoteReply With Quote