#### justmeok

##### New Member

- Joined
- Jul 27, 2011

- Messages
- 42

- Office Version
- 365

- Platform
- Windows

I need some help on a formula to return yes, no or leave blank in the following circumstances.

I have a column of 4 rows and these rows will either be blank or have yes or no. I want a formula to do nothing if all cells are blank, or return yes if all cells are yes, or return no if at least one cell is no. The formula is to do nothing if any of the 4 cells are blank as well. In other words 4 x yes are needed for yes, 4 x populated cells with 1 x No returns No otherwise do nothing

I have played around with IF, AND, OR and ISBLANK formulas but I'm getting nowhere

Any help will be greatly appreciated