Thanx buddy,

But I am very sorry, probably I was not able to present my question
appropriately.

Lets consider a formula for:

if ( Entry in B1, IS NOT PRESENT IN THE ARRAY A1:A100, then "INVALID ENTRY",
otherwise "CORRECT ANSWER")

Sorry for any problems but please do solve this problem of mine urgently.

"Prasadkakarla" wrote:

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