0

So I'm trying to create a tracker where I can gauge a pass/warning/fail status for each category. Under "Report Status", I wanted a function that can put out the text "Fail" if one of the months has a "fail" tag or two "warning" tags, a "Warning" if there is only one "warning" tag, and then "pass" otherwise.

I've tried to scaffold my function as follows:

=(IF(E3:K3,"Fail"), "Fail", if(E3:K3,"Warning"),"Warning")

But I'm only getting errors.

I know this is probably a very easy code to do but I'm an absolute noob so I would appreciate any form of help!!

enter image description here

1

1 Answer 1

0
=IF(
    OR(
        COUNTIF(E3:K3,"Fail") >= 1,
        COUNTIF(E3:K3,"Warning") >= 2
    ),
    "Fail",
    IF(
        COUNTIF(E3:K3,"Warning") = 1,
        "Warning",
        "Pass"
    )
)

This should do it. Nested IF's felt like the best choice for this since it's very specific.

2
  • Worked like a charm, thanks so much! May 25 at 13:41
  • Your welcome! Please do consider accepting my answer (by clicking the checkmark), this is to mark this question as resolved.
    – David Tan
    May 25 at 15:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.