How to Add and Equate for an Empty Field?

We have an intake sheet that we just updated to include a new field that will only have data input on a rare occasion. I need to figure out how to update my formula to take into account that input as we are measuring as a pass/fail system but I need it not to affect when it's empty.

Here's the current formula:

=IF(AND([Helper 1]@row = "0", [Helper 2]@row = "0", [Helper 3]@row = "0"), "Pass", IF(OR([Helper 1]@row = "1", [Helper 2]@row = "1", [Helper 3]@row = "1"), "Fail", ""))

Here's my partially updated version with the new field:

=IF(AND([Helper 1]@row = "0", [Helper 2]@row = "0", [Helper 3]@row = "0", [HR 1]@row = "0"), "Pass", IF(OR([Helper 1]@row = "1", [Helper 2]@row = "1", [Helper 3]@row = "1", [Hr 1]@row = "1"), "Fail", ""))

But I need to know what else to add so that if HR 1 or Helper 2 are empty, it doesn't affect the pass/fail outcome. I've tried a couple of additions like IFERROR or ISBLANK, but I don't think I was adding them correctly to get them to work right

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

Does it work if you plug this in?

=IF(OR([Helper 1]@row = "1", [Helper 2]@row = "1", [Helper 3]@row = "1", [Hr 1]@row = "1"), "Fail", "Pass")

All comments

Paul Newcome

Does it work if you plug this in?

=IF(OR([Helper 1]@row = "1", [Helper 2]@row = "1", [Helper 3]@row = "1", [Hr 1]@row = "1"), "Fail", "Pass")

Ashley Klaers

@Paul Newcome

That seems to work and function just fine.

Is there a way to edit the formula so if there's no responses, it remains blank?

Paul Newcome

Try this one:
=IF(OR([Helper 1]@row <> "", [Helper 2]@row <> "", [Helper 3]@row <> "", [Hr 1]@row <> ""), IF(OR([Helper 1]@row = "1", [Helper 2]@row = "1", [Helper 3]@row = "1", [Hr 1]@row = "1"), "Fail", "Pass"))

Ashley Klaers

That seemed to work! Thanks @Paul Newcome!

Paul Newcome

Happy to help. 👍️

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.