#DIV/0! Errors

My formula is as follows:

=(P6/100*55-P30)/(P6/100*55)*100

I keep getting the #DIV/0! error. Can you help?

What are your values in P6 and P30?

Steve

P6 must be zero or blank. Try this to avoid the error:

=IF(P6=0,0,(P6/100*55-P30)/(P6/100*55)*100)

Hope this helps.

Pete

It works Pete, Thank you so much. I knew someone out there had an answer for
me. I am surprised that microsoft help could not assist me. Thanks again.

Cindy

"Pete_UK" wrote:

> P6 must be zero or blank. Try this to avoid the error:
>
> =IF(P6=0,0,(P6/100*55-P30)/(P6/100*55)*100)
>
> Hope this helps.
>
> Pete
>
>

Thanks for feeding back, Cindy.

Pete

Is the value in P6 0? That would explain it, even though you have P6 in the
numerator, 0/0 will still give #DIV/0.

--
Regards,
Dave


"Cindy" wrote:

> My formula is as follows:
>
> =(P6/100*55-P30)/(P6/100*55)*100
>
> I keep getting the #DIV/0! error. Can you help?