=IF(A1+B1<0,IF(A10,A1,IF(B10,B1,0)),0)

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"profmorse" wrote in message
...
how can I build an If statement that answers the following; If A+B<0 then
chose A only if A is greater than 0, otherwise chose B, only if B is
greater
than zero, otherwise 0.