#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?

#DIV/0! Errors
 

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

#DIV/0! Errors
 

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?

#DIV/0! Errors
 

What are your values in P6 and P30?

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=527637

#DIV/0! Errors
 

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

#DIV/0! Errors
 

Thanks for feeding back, Cindy.

Pete