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",""))
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!
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",""))
Both versions work! Thank you!
Bookmarks