Return Blank in column

Katye Reed

Hello,

I am trying to populate a Pass/Fail Column based of the answers in a pervious column. I am using IF formula, =IF([1. Pass Meds]@row = "Yes", "Pass", "Fail") but not sure how I should add in if blank.

Any help is much appreciated!

Nic Larsen

=IF(ISBLANK([1. Pass Meds]@row), "", IF([1. Pass Meds]@row = "Yes", "Pass", "Fail"))

Nic Larsen

=IF(ISBLANK([1. Pass Meds]@row), "", IF([1. Pass Meds]@row = "Yes", "Pass", "Fail"))

Katye Reed

Thank you so much!

Bassam Khalil

Excellent @Nic Larsen