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

Find more posts tagged with

Formulas

Conditional Formatting

Accepted answers

Kelly Moore

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

All comments

Kelly Moore

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)

Does this work for you?

Kelly

Mark Muenzen

Worked perfectly and you increased my knowledge base! Thank you @Kelly Moore!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.