Results 1 to 3 of 3

Thread: Excel noob needs help

  1. #1

    Excel noob needs help



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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!

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,518
    Articles
    0
    Excel Version
    Excel 2016
    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",""))


  3. #3
    Both versions work! Thank you!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •