View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Titanium
 
Posts: n/a
Default excel divide by zero error

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,B12/(B12+H12))
--
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... :)