if? or? then? I need help.

[rd7742]

I need cell X to have one of three possible outcomes, 1,2, or 3, all depending on whether cell Y or Z are populated with any value.

Cell X=1 if cell Y and Z are blank.
Cell X=2 if cell Y is populated and Z is blank
Cell X=3 if Cell Y and Cell Z are populated.

Any help is greatly appreciated.

 

[Joe4]

Welcome to the Board!

Try (for row 1):

=IF(AND(Y1="",Z1=""),1,IF(AND(Y1<>"",Z1=""),2,IF(AND(Y1<>"",Z1<>""),3,"No conditions met")))

Note you did not mention what to return if Y is blank and Z is populated. In that case, it will return "No conditions met".

 

[rd7742]

Ah, thank you. Formula worked. So the "<>" represents any value?

 

[Joe4]

Ah, thank you. Formula worked. So the "<>" represents any value?

="" means "equals nothing" (essentially is blank)
<>"" means "NOT equal to nothing" (essentially, is not blank)