'Google Sheets - Show text in cell based on 3 other cells - 1: Not blank, 2+3: Yes/No

I'd like my output cell to show "Success" / "Not quite there" based on 3 cells:

  1. Blank / not blank
  2. Yes / No
  3. Yes / No

My issue is with combining the "isblank" in the "IF".

The below formula is the closest I've gotten and it's not working -

=(if(and(E3<>,F3="Yes",G3="Yes"),"Success!","Not quite there"))

Would love your advice!

arraysif-statementgoogle-sheetsbooleannested-if


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions