Ok then.....under those circumstances my sheet is working fine, returning 0%
in the case where both are equal.........are you still getting the 100% , or
has the problem gone away..........

Vaya con Dios,
Chuck, CABGx3



"chedd via OfficeKB.com" wrote:

chedd wrote:
Hi

[quoted text clipped - 6 lines]
formula to show the percentage value is =IF(C9=0,"0%",C9/B9). Can anyone
help

I have tried to respond to the reply I had, but have been blocked to give a
reply. I have tried the formula below, but I still having 100% showing in
cell D. Has any one have any further ideas?


Sorry i took the formula from B10 instead B11 (=B11-'Apr 06 monthly report'!
B11)

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200606/1