Thread: LOGICAL OPERATOR "IF" FOR AN ARRAY
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
FARAZ QURESHI FARAZ QURESHI is offline
external usenet poster
  
Posts: 553
Default LOGICAL OPERATOR "IF" FOR AN ARRAY
Can V have a formulas like the following?

if ( any of the cells in array A1:A100 = "LOS ANGELES" , then "AMERICAN",
otherwise "NON-AMERICAN")

OR

if ( any of the cells in array A1:A20 < "40" , then "FAIL", otherwise "PASS")
Reply With QuoteReply With Quote