Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Format- Negative Percentages | Excel Discussion (Misc queries) | |||
How do I Calculate Percentages for each number in a column? | Excel Discussion (Misc queries) | |||
Adding percentages in a column and automatic formating of contents | Excel Worksheet Functions | |||
Calculating Percentages with Variables | Excel Worksheet Functions | |||
Percentages error | Excel Discussion (Misc queries) |