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