Results 1 to 2 of 2

Thread: Categories problem

  1. #1

    Categories problem



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

    Hello everyone!

    I really need your help!

    This is my problem: I have 2 columns with 2 different values (2 different numbers, a number and a 0, a number and a N/A error), like this:

    A B

    1 2

    1 0

    0 2

    1 N/A




    What I need is the C column to take the value of the column A, if there's a number in both columns, the value of A if B equals O or N/A, and the value of B if A equals 0 or N/A.

    Thank you so much!

    Mya

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    Try:

    =IFERROR(IF(A1>0,A1,B1),B1)


Posting Permissions

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