Results 1 to 10 of 10

IF with 3 variables

Threaded View

  1. #1
    Registered User
    Join Date
    05-18-2010
    Location
    Europe
    MS-Off Ver
    Excel 2010
    Posts
    54

    IF with 3 variables

    Hi guys,

    I think it is an easy problem for you.
    Please find below the cells. I want to create a formula in D that tells me the type of data we are working on based on value in column a,b and c.
    The logic for d2 should be
    "if a2 is Y and b2 and c2 are N then give me apple" and
    "if b2 is Y and a2 and c2 are N then give me banana" and
    "if c2 is Y and b2 and a2 are N then give me pear"

    there is can be only a "Y" per raw.

    a b c d
    1 Apple Banana Pear Type
    2 Y N N Apple
    3 N Y N Banana
    4 N N Y Pear

    Thanks in advance for your help.
    Regards,
    Last edited by TRS; 01-11-2011 at 12:05 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1