Multiple Conditions
Helpful = YES!!! Very. Many thanks
"Eduardo" wrote:
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" wrote:
Hi
Thank you for your help -
Unfortunately, that did not work - returns #NAME?
"KS" wrote:
Hi all -
Hoping someone can help he
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!
|