View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
roadkill roadkill is offline
external usenet poster
 
Posts: 173
Default Simple SumIF Question?

Hello, I am having trouble with a SumIf question that I think would be simple
but doesn't seem to work. Basically I am just dividing two columns but when
there is a zero, it gives me the div/o error message. Here is my current
calculation:

=H3/G3

What I would like is that if H3 is zero then to just return a zero but to do
the division if H3 is greater than zero.

Thank you