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