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!!