Multiple Conditions

[KS]

Hi all -
Hoping someone can help here:

Columns A and B contain either a Y or N value; C contains a dollar amount
I want to write the Value of C into either of 2 new columns, say D and E

In all cases if A = N then D and E = "N/A"
If A = Y and B = N, then D = dollar amount from C
If A = Y and B = Y, then E = dollar amount from C

Thanks for any assistance!

 

[Eduardo]

Hi,
assuming information starts in row 1 try


In column D enter
=if(A1="N","N/A",if(and(A="Y",B="N"),C1,"")

In column E enter

=if(A1="N","N/A",if(and(A="Y",B="N"),"",C1)

 

[Eduardo]

Hi,
It didn't work in both columns??
check you don't have any space in front of the N or the Y

if this was helpful please say yes

 

[KS]

Helpful = YES!!! Very. Many thanks

Hi,
It didn't work in both columns??
check you don't have any space in front of the N or the Y

if this was helpful please say yes

 

[KS]

I have another:

Column N contains numeric values (page counts)
I need to add the sum of N under 2 conditions:

1) Total of N for all records where A= Y and B= Y
2) Total of N for all records where A= Y and B= N

These 2 totals will reside in two diff cells - doesn't matter where, say M1
and M2 respectively.

 

[Eduardo]

Hi
In M1 enter
=SUMPRODUCT(--(A:A="Y"),--(B:B="N"),N:N)

in M2 enter

=SUMPRODUCT(--(A:A="Y"),--(B:B="y"),N:N)

is this was helpful please click on yes in the left corner of the post.
thank you