check true and false value

[mwvirk]

how i can avoid getting result in C if A and/or B are blank?

MMK Clients Data.xlsx
	A	B	C
28	W801	W801	TRUE
29	W802	W802	TRUE
30	W803	W803	TRUE
31			TRUE
32			TRUE
33			TRUE
34			TRUE
35			TRUE
Verify Accounts

Cell Formulas
Range	Formula
C28:C35	C28	=A28=B28

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C1:C500	Cell Value	contains "FALSE"	text	NO
C1:C500	Cell Value	contains "TRUE"	text	NO

 

[hagia_sofia]

Try:

=IF(OR(ISBLANK(A28),ISBLANK(B28)),"",A28=B28)

 

[Eric W]

Also:

=IF(COUNTA(A28:B28)=2,A28=B28,"")

 

[AlphaFrog]

Yet another...

=AND(A28<>"", A28=B28)