View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Otto Moehrbach Otto Moehrbach is offline
external usenet poster
 
Posts: 1,090
Default 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.