Just a guess.....

If you want to test that every non-blank cell in Col_A
matches the value in cell B1

Then try this:
C1: =IF(AND(COUNTA(A:A)<0,COUNTIF(A:A,B1)=COUNTA(A:A) ),"Pass","FAIL")

Note: the COUNTIF function is NOT case-sensitive.

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"joker_r_me" wrote:

I need to create an (if) formula that isn't (if cell a = cell b then pass,
fail)... I need to make it more like (if Colum A = cell b then pass, fail)...
is that possible and how do I create it?