Thread: IF statements
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Brad Brad is offline
external usenet poster
 
Posts: 846
Default 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.