Just another option,

=((A1+B1)<0)*MAX(A1,B1,0)
--
HTH

Sandy
Retired for Work
But hopefully not from Life


with @tiscali.co.uk


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