IF & ISBlank Function

Shann Omuto

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")

 

Debbie Sawyer

Hi

You could try:

=IF(ISBLANK(Score2), "", IF(Score2 < 80, "Failed", "Passed"))

Worked for me

Kind regards

​Debbie Sawyer Consultant & Training Manager

 

 

Mike Wilday

Try this nested IF statement that checks for blank scores and keeps the field blank. I also updated your formula to work in any row. 

=IF(ISBLANK(Score@row), "", IF(Score@row < 80, "Failed", "Passed"))