Percentages
 

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

Percentages
 

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


--
foolsgold1970
------------------------------------------------------------------------
foolsgold1970's Profile: http://www.excelforum.com/member.php...o&userid=28562
View this thread: http://www.excelforum.com/showthread...hreadid=482230

Percentages
 

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

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=482230

Percentages
 

Thanks Ron your a Saint.

Terry


--
foolsgold1970
------------------------------------------------------------------------
foolsgold1970's Profile: http://www.excelforum.com/member.php...o&userid=28562
View this thread: http://www.excelforum.com/showthread...hreadid=482230