Percentages

[foolsgold1970]

Hi there, hope somebody out there in cyberworld can help me with the following probably easy to answer post.

I have a number in box A1 lets say 100. This number is what I have dealt with over the month. In box B1 I have 10 and in box C1 I have 10. The numbers in B1 and C1 are figures within the 100 that I have missed for the month. How do I calculate out of 100% what I have achieved.

I know how to calculate what percentage I have missed,
i.e =sum(B1:C1)/A1*100 = 20%.

ACHIEVED A1 = 100 MISSED B1 = 10 + C1 = 10

PERCENTAGE ACHIEVED = ?

Thanks in advance for any help given.

Terry

[foolsgold1970]

I should also state that the figure of 100 is what I have dealt with and the 2 figures of 10 have missed there target times out of that 100.

Thanks again

Terry

[Ron Coderre]

How about this:
=(1-SUM(B1:C1)/A1)*100

Does that help?

Regards,
Ron

[foolsgold1970]

Thanks Ron your a Saint.

Terry