Another Formula Question

Z

zoomzoom632

I want to have a cell equal the sum of two cells, only if the value of one of
the cells is greater than zero. If the value of the cell is less than or
equal to 0, i want the value of the cell to equal 0.

Example:

sum(E18:E19) if E19>0, or =0 if E19≤0.

Hope someone can help.
 
A

Access_Rookie

I'm not sure I understand you correctly but try putting this in cell C1 using
A1 and B1 for testing. If it is what you looking for, modify it to your needs.

=IF(A1*B1<=0,0,A1+B1)

Hope this helps!!
 
Top