I am trying to test whether or not the score inputted is greater than 80 or less than 80.
If the score is greater than 80 , I would like my status column to populate with a string labeled "Passed".
If the score is less than 80 I would like my status column to populate with a string labeled "Failed".
Heres the issue, I am unable to account for blank columns. My hope is to nest the ISBLANK function inside of the if statement, to prevent the function from reading blank cells as a "Failed".
Is this possible?
See image & function I am currently using below:
=IF(Score2 < 80, "Failed", "Passed")
