Exact if not blank

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I use the formula below to compare two values as long as they are not blank

=IF(AND((A1<>""),(C1<>"")),EXACT(A1,C1),"-")

However, I need to compare the value in A1 against other cells within the same formula as long as none are blank

I'm thinking i should somehow combine the formula above with
=AND(EXACT(A1,C1),AND(EXACT(A1,E1)))
but I havent been able to. Can someone please help me?

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
How about some thing like this


=IF(OR(A1="", C1="", E1=""),"-",AND(EXACT(A1,C1),EXACT(A1,E1)))


or may be even
=IF(A1="","-",AND(EXACT(A1,C1),EXACT(A1,E1)))