Excel noob needs help

[Ev_M]

Hello,

I have zero experience in Excel with anything more complicated than summing a column. I need help.

I need a formula that does the following:

If Column A has data in it, but not Column B, then Column E gets value X

If Column B has data in it, but not Column A, then Column E gets value Y

If Column A and Column B have data in them, then Column E gets value Z (Z = X & Y).

All inputs and values are text.

Thank you!

[NBVC]

Try:

=IF(AND(A2<>"",B2=""),"X",IF(AND(A2="",B2<>""),"Y",IF(AND(A2<>"",B2<>""),"Z","")))

or simplified:

=IF(A2<>"",IF(B2="","X","Z"),IF(B2<>"","Y",""))

[Ev_M]

Both versions work! Thank you!