Multiple Criteria IF Statement

We are trying to produce this formula to give us a pass, fail or ready for testing status based on the columns below and are having some issues.

Pass: when Tester passes equals the number of Test cases per tester

Fail: occurs when there are any fails in the tester fail column

Ready to Test: cases per tester is not equal to passed or there is no fails

Thank you for your help!

=IF([RCC - Test Cases Per Tester]@row = [RCC - Tester Passes]@row, "Pass", IF([RCC - Tester Fails]@row > 0, "Fail", IF(AND([RCC - Test Cases Per Tester]@row <> [RCC - Tester Passes]@row, AND([RCC - Tester Fails]@row = 0, "Ready to Test", "")))))

Find more posts tagged with

Accepted answers

Lucas Rayala

Sorry for the multiple posts -- your original code broke because you have a second "AND" statement and you didn't close them properly.

=IF( [RCC - Test Cases Per Tester]@row = [RCC - Tester Passes]@row, "Pass",

IF([RCC - Tester Fails]@row > 0, "Fail",

IF(AND([RCC - Test Cases Per Tester]@row <> [RCC - Tester Passes]@row, [RCC - Tester Fails]@row = 0), "Ready to Test", "")))

But I'd still start with the "Fail" as that's the simplest scenario.

All comments

Lucas Rayala

If the "Fail" is a trump card, start there.

=IF([RCC - Tester Fails]@row > 0, "Fail",

IF([RCC - Test Cases Per Tester]@row = [RCC - Tester Passes]@row, "Pass",

IF([RCC - Test Cases Per Tester]@row <> [RCC - Tester Passes]@row, "Ready to Test","")))

This should work. Let me know if you have isues!

Lucas Rayala

You might actually be able to simplify it to:

=IF([RCC - Tester Fails]@row > 0, "Fail",

IF([RCC - Test Cases Per Tester]@row = [RCC - Tester Passes]@row, "Pass", "Ready to Test"))

Lucas Rayala

Sorry for the multiple posts -- your original code broke because you have a second "AND" statement and you didn't close them properly.

=IF( [RCC - Test Cases Per Tester]@row = [RCC - Tester Passes]@row, "Pass",

IF([RCC - Tester Fails]@row > 0, "Fail",

IF(AND([RCC - Test Cases Per Tester]@row <> [RCC - Tester Passes]@row, [RCC - Tester Fails]@row = 0), "Ready to Test", "")))

But I'd still start with the "Fail" as that's the simplest scenario.

Kendra Hillmer

That worked! Thank you SO much Lucas!

I really appreciate your help - thanks again!

Lucas Rayala

No problem @Kendra Hillmer, 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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.