|The formula already deals with the number grades. I got the impression that if Fail was not present, you want to return the lowest grade. That's what the formula does.|
If the COUNTIF portion of the formula finds at least one occurrence of the word Fail, then the IF function is TRUE and the formula will return "Fail".
If the COUNTIF portion does not find any occurrence of the word Fail, then the IF will be FALSE, and the MIN(range) clause will be evaluated, returning the lowest grade in the range.
Isn't that what you want?
If so, then you should look up how an IF function works. Perhaps it will make more sense. Let me know.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
message edited by DerbyDad03