Simple SumIF Question?

R

RoadKill

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
 
C

Conan Kelly

RoadKill

Don't you mean if G3 is zero? If H3 is 0, you should get 0, but you will
get a divide by 0 error if G3 is 0.

=If(G3=0,0,H3/G3)

HTH,

Conan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top