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