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
------------------------------------------------------------------------
foolsgold1970's Profile: http://www.excelforum.com/member.php...o&userid=28562
View this thread: http://www.excelforum.com/showthread...hreadid=482230