Check Box with multiple criteria
I am trying to get a checked box: If Column A value = Column B value, check box. However, I am also getting checked boxes when A and B are both blank which should not happen.
Current formula is:
=IF(AND([TRACcess Serial Number as Per TRACcess Manager]@row = [TRACcess Serial Number As Reported by Tech]@row), 1, 0)
Is there a syntax I can add to say if A = B but A ≠ blank, then 1,0
Help Article Resources
Check out the Formula Handbook template!