LOGICAL OPERATOR "IF" FOR AN ARRAY
 

try this :

=IF(B2="LOSANGELS","AMERICANS","NON-AMERICANS")

same way u can try numbers also

=if(B2<40,"fail","Pass")
--
Name : K.Prasad
Inventory Manager
CRYSTALGALLERY
DUBAI



"FARAZ QURESHI" wrote:

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")