"Rumy" wrote:
I have dollar amounts in A,B,C,D,E,F columns. I need a result in G[.]
it should be A+B+C. If A+B+C equals 0 the result should be D. If D
also equals 0 then the result should be E - F. Please help.

=if(A1+B1+C1<0, A1+B1+C1, if(D1=0, E1-F1, D1))