Another Formula Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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!!
 
Back
Top