Thread: IF(OR statement not working
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MyVeryOwnSelf[_3_] MyVeryOwnSelf[_3_] is offline
external usenet poster
  
Posts: 56
Default IF(OR statement not working
=IF(OR(ISNUMBER(MATCH(H3,PastLoad!$H3,0))*MATCH(F3 ,PastLoad!$F3,0)),"","NEW")

The post doesn't say much about the objective or about what's going wrong, but if I had to make a wild guess maybe this would help:

=IF(OR(ISNUMBER(MATCH(H3,PastLoad!$H3,0)),
ISNUMBER(MATCH(F3,PastLoad!$F3,0))),"","NEW")
Reply With QuoteReply With Quote