Nested formula

[blandreth]

I'm looking for a formula that will provide the following result:

If b9= selection "a","b",or "c" and b11 is populated then result would be "ok to save"

If b9= selection "D", then look for B20 and if it is populated the result would be "ok to save"

otherwise result would be "not ready to save"

for example - if b9="a" and b11 was empty result would be "not ready to save" - if b9="a" and b11 is populated then result would be "ok to save"

for example - if b9="d" and b20 was empty result would be "not ready to save" - if b9="d" and b20 is populated then result would be "ok to save"

Running Excel 2016

Any suggestions would be greatly appreciated.

Thanks,
Brian

 

[blandreth]

Thanks!

I appreciate all of the responses.