IF statements
 

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.

IF statements
 

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

IF statements
 

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.

IF statements
 

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.

IF statements
 

Yes, that would work just as well - both a1 and b1 cannot be positive and
meet the first condition - and if both of them are negative you will still
get zero as an answer


"Sandy Mann" wrote:

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.

profmorse

=--IF(and(A1+B1<0,MAX(A1:B1)0),MAX(A1:B1))

happy holidays hohoho..:)
romelsb @ banter