Another Formula Question
 

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 E190, or =0 if E19‰¤0.

Hope someone can help.

Another Formula Question
 

Try
=IF(E19<=0,0,E18+E19)

"zoomzoom632" wrote in message
...
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 E190, or =0 if E19?0.

Hope someone can help.

Another Formula Question
 

Try:

=(E190)*(E19+E18)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"zoomzoom632" wrote in message
...
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 E190, or =0 if E19‰¤0.

Hope someone can help.

Another Formula Question
 

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!!

"zoomzoom632" wrote:

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 E190, or =0 if E19‰¤0.

Hope someone can help.