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.
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.
Hi,
that would be something like
=IF(OR(AND(listA=X,listB=W),listB=Y),0,C1)
Thanks that worked perfectly!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks