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.

"Mike" wrote:

For each of your formula try


=IF(A1:A100="Los Angeles","American","Not American")

=IF(MIN(A1:A20)<40,"Fail","Pass")

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