IF(IS BLANK) - Multiple yes no criteria

Michelle Lempert

I am trying to find a way to have this function look at 4 different cells and if any of them are not blank, it want it it say, "yes." If they are all blank, i want it to say, "no." I guess I need 4 of these strung together with OR. But I can't make it work:

=IF(ISBLANK([Outstanding Audit]@row), "No", "Yes")

Michelle Lempert

This is what I currently have, but it doesn't work unless there's data in all four cells:

=IF(OR([Outstanding Audit]@row <> ""), IF(OR([Outstanding Tax]@row <> ""), IF(OR([Outstanding Insurance]@row <> ""), IF(OR([Outstanding Quarterly Rent Rolls]@row <> ""), "yes", "no"))))

J Tech

Hi @Michelle Lempert

Your current formula uses nested IF statements and checks if each of the four cells has data before returning "yes". If any of the cells are empty, it will return "no". However, since you want to check if any of the cells have data, you should use the OR function for each cell check instead of the IF function.

Here's an updated formula that should work for your requirement:

=IF(OR([Outstanding Audit]@row <> "", [Outstanding Tax]@row <> "", [Outstanding Insurance]@row <> "", [Outstanding Quarterly Rent Rolls]@row <> ""), "yes", "no")

This formula checks if any of the four cells have data using the OR function and returns "yes" if there is data in any of the cells, otherwise it returns "no".