profmorse
=--IF(and(A1+B1<0,MAX(A1:B1)0),MAX(A1:B1))
happy holidays hohoho..:)
romelsb @ banter
Quote:
|
Originally Posted by Brad
Another solution
=if(a+b<0,max(a,0),max(b,0))
"profmorse" wrote:
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.
|