PASS or FAIL

Hi,

I'm looking for a solution for the following issue:

i have three cells A1, A2, and A3, if A1=A2=A3 it should show PASS in other Cell e.g. A4 if not = it should show FAIL


PASS or FAIL should be visible only if we fill all 3 cells


Thank You for help

=IF(AND(A1=B1,B1=C1),"Pass","Fail")

Should be ..

=IF(AND(A1=A2,A2=A3),"Pass","Fail")

the problem is that even when cells are empty it shows PASS. How to change this function to make visible only if we type something in Cells A1, A2 and A3.

Sorry for my English

This will leave A4 blank if one of the cells is empty.

=IF(COUNT(A1:A3)<3,"",IF(AND(A1=A2,A2=A3),"Pass","Fail"))

Windy

Yes .. I had thought about blank cells ... but you have a solution from "Windy58" (thanks)

thank you very much for help guys working fine