+ Reply to Thread
Results 1 to 3 of 3

Nesting IF/AND/Or statements

  1. #1
    Registered User
    Join Date
    10-13-2007
    Posts
    20

    Nesting IF/AND/Or statements

    I have two cells that each contain their own lists (listA=A1, listB=B1).
    I'm trying to figure out how to say:

    If the selection from (listA= X AND listB=W )or the selection from listB=Y output 0, otherwise output data from C1.

    Thank you.
    Last edited by ivwshane; 03-22-2009 at 05:17 PM.

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Nesting IF/AND/Or statements

    Hi,

    that would be something like

    =IF(OR(AND(listA=X,listB=W),listB=Y),0,C1)

  3. #3
    Registered User
    Join Date
    10-13-2007
    Posts
    20

    Re: Nesting IF/AND/Or statements

    Thanks that worked perfectly!

+ Reply to Thread

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