No problem:

What the IF does is to say that if B12 is zero, don't both to do the
division, just return zero. This approach works if B12 and H12 are both zero.

Another case that you didn't mention is something like B12=-1 and H12=+1 In
this case you would want something like:

=IF((B12+H12)=0,0,B12/(B12+H12))

I like this form better because it covers both cases.


--
Gary's Student


"Titanium" wrote:

hate to bother you yet again, but I'm trying to make sure that I understand
the statement you wrote... can you please explain the syntax, I'm just trying
to make better sense of it than i'm doing on my own... :)

"Gary''s Student" wrote:

=if(B12=0,0,))
--
Gary's Student


"Titanium" wrote:

I'm trying to write a formula to calculate the percentage of two cells. The
simplified formula reads:
=B12/(B12 + H12)

The problem is when H12 and B12 both = zero. Zero divided by zero = divide
by zero error.

The desired result, display 0%

I looked at the online help, and it gives me a sample formula, but for the
life of me, i just can't seem to get it to work out with 'my desired
result'...

help... please... :)