#DIV/0! Errors

[Guest]

My formula is as follows:

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

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

 

[Pete_UK]

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

 

[Guest]

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.

 

[SteveG]

What are your values in P6 and P30?

Steve

 

[Guest]

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]

Thanks for feeding back, Cindy.

Pete