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)

"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!