Check Box with multiple criteria
Hello 
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
Thank you
Best Answer

Hey @Mark Muenzen
The IF/AND is only used when simultaneous conditions exist. IF the formula was only A=B, we would not use AND.
But since you found that an additional condition is needed in order to obtain the expected result, the formula becomes:
=IF(AND([TRACcess Serial Number as Per TRACcess Manager]@row = [TRACcess Serial Number As Reported by Tech]@row, [TRACcess Serial Number as Per TRACcess Manager]@row<>""),1)
The <> means 'is not'. The double quotes mean blank. The formula reads if [TRACcess Serial Number as Per TRACcess Manager]@row equals [TRACcess Serial Number As Reported by Tech]@row AND the [TRACcess Serial Number as Per TRACcess Manager]@row is not blank, then 1. If these are not true then the formula does nothing, which will leave the cell blank.
Does this work for you?
Kelly
Answers

Hey @Mark Muenzen
The IF/AND is only used when simultaneous conditions exist. IF the formula was only A=B, we would not use AND.
But since you found that an additional condition is needed in order to obtain the expected result, the formula becomes:
=IF(AND([TRACcess Serial Number as Per TRACcess Manager]@row = [TRACcess Serial Number As Reported by Tech]@row, [TRACcess Serial Number as Per TRACcess Manager]@row<>""),1)
The <> means 'is not'. The double quotes mean blank. The formula reads if [TRACcess Serial Number as Per TRACcess Manager]@row equals [TRACcess Serial Number As Reported by Tech]@row AND the [TRACcess Serial Number as Per TRACcess Manager]@row is not blank, then 1. If these are not true then the formula does nothing, which will leave the cell blank.
Does this work for you?
Kelly

Worked perfectly and you increased my knowledge base! Thank you @Kelly Moore!
Help Article Resources
Categories
Check out the Formula Handbook template!