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

Improve this question
1

1 Answer 1

Reset to default
1 
=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.

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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