=IF(AND(OR statement needed?
 

How do i write a formula for the following? I am very close but keep having
problems getting it perfect. I've tried so many combos of If(or(and (w/
lookups, not( etc. but can't get it.

data already in spreadsheet:

column A can only either be "x" or "y".
column B can be any name
column C is a $ value
column D is list of particular names

Need single formula to say:
if A is "x" = return value from C no matter what
if A is "y" = return value from C ***unless B is on the list in D = then
return 0.

Thanks in advance!

=IF(AND(OR statement needed?
 

Try this:

=IF(A1="x",C1,IF(D1="B",0,C1))

HTH,
Elkar


"bracket89" wrote:

How do i write a formula for the following? I am very close but keep having
problems getting it perfect. I've tried so many combos of If(or(and (w/
lookups, not( etc. but can't get it.

data already in spreadsheet:

column A can only either be "x" or "y".
column B can be any name
column C is a $ value
column D is list of particular names

Need single formula to say:
if A is "x" = return value from C no matter what
if A is "y" = return value from C ***unless B is on the list in D = then
return 0.

Thanks in advance!

=IF(AND(OR statement needed?
 

I think you want a formula like this assuming that the list is in te colum d
otherwise restrict the column

=IF(OR(A1="x",AND(A1="y",ISNA(MATCH(B1,$D:$D,0))=F ALSE)),C1,"")

--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"bracket89" wrote:

How do i write a formula for the following? I am very close but keep having
problems getting it perfect. I've tried so many combos of If(or(and (w/
lookups, not( etc. but can't get it.

data already in spreadsheet:

column A can only either be "x" or "y".
column B can be any name
column C is a $ value
column D is list of particular names

Need single formula to say:
if A is "x" = return value from C no matter what
if A is "y" = return value from C ***unless B is on the list in D = then
return 0.

Thanks in advance!