|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 11th, 2009, 02:19 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel Percentage
I am drawing a blank. I am developing a comprehensive budget and am required
to show the percentage for each of the expenditures. In the end, the percentages should total to 100. Example, $66.00 out of $100.00 = 20% $44.00 out of $100.00 = 10% $33.00 out of $100.00 = 90% I do not remember how to put formulate the formula in excel 2007. Please help. -- Thank you. You are awesome! 
|
|
#2
March 11th, 2009, 02:45 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Excel Percentage
I don't understand your figures
but to get % of any number enter the number in A1 percentage in B1 either as 0.10 for 10% or format it as a percentage and enter 10 then enter this in C1 =A1*B1 "S" wrote: I am drawing a blank. I am developing a comprehensive budget and am required to show the percentage for each of the expenditures. In the end, the percentages should total to 100. Example, $66.00 out of $100.00 = 20% $44.00 out of $100.00 = 10% $33.00 out of $100.00 = 90% I do not remember how to put formulate the formula in excel 2007. Please help. -- Thank you. You are awesome!
|
|
#3
March 11th, 2009, 03:03 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Excel Percentage
Hi Sheeloo
Please allow me to re-explain. I have three categories that should total to $500.00 and I additionally need to show these values as percentages. Category A is $66.00 (now I need to show $66.00 in the percentage phase is X% of the $500.00). So in the end, I am attempting to show the breakdown in the percentage value for each of the categories. I hope that I explained what I need to both of our understanding. Thank you again. -- Thank you. You are awesome! "S" wrote: I am drawing a blank. I am developing a comprehensive budget and am required to show the percentage for each of the expenditures. In the end, the percentages should total to 100. Example, $66.00 out of $100.00 = 20% $44.00 out of $100.00 = 10% $33.00 out of $100.00 = 90% I do not remember how to put formulate the formula in excel 2007. Please help. -- Thank you. You are awesome!
|
|
#4
March 11th, 2009, 03:18 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Excel Percentage
Just divide:
A1 = 66 B1 = 500 =A1/B1 Format as Percentage 66 is 13.2% of 500 -- Biff Microsoft Excel MVP "S" wrote in message ... Hi Sheeloo Please allow me to re-explain. I have three categories that should total to $500.00 and I additionally need to show these values as percentages. Category A is $66.00 (now I need to show $66.00 in the percentage phase is X% of the $500.00). So in the end, I am attempting to show the breakdown in the percentage value for each of the categories. I hope that I explained what I need to both of our understanding. Thank you again. -- Thank you. You are awesome! "S" wrote: I am drawing a blank. I am developing a comprehensive budget and am required to show the percentage for each of the expenditures. In the end, the percentages should total to 100. Example, $66.00 out of $100.00 = 20% $44.00 out of $100.00 = 10% $33.00 out of $100.00 = 90% I do not remember how to put formulate the formula in excel 2007. Please help. -- Thank you. You are awesome!
|
|
#5
March 11th, 2009, 03:28 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Excel Percentage
Thank you! Thank you!
-- Thank you. You are awesome! "T. Valko" wrote: Just divide: A1 = 66 B1 = 500 =A1/B1 Format as Percentage 66 is 13.2% of 500 -- Biff Microsoft Excel MVP "S" wrote in message ... Hi Sheeloo Please allow me to re-explain. I have three categories that should total to $500.00 and I additionally need to show these values as percentages. Category A is $66.00 (now I need to show $66.00 in the percentage phase is X% of the $500.00). So in the end, I am attempting to show the breakdown in the percentage value for each of the categories. I hope that I explained what I need to both of our understanding. Thank you again. -- Thank you. You are awesome! "S" wrote: I am drawing a blank. I am developing a comprehensive budget and am required to show the percentage for each of the expenditures. In the end, the percentages should total to 100. Example, $66.00 out of $100.00 = 20% $44.00 out of $100.00 = 10% $33.00 out of $100.00 = 90% I do not remember how to put formulate the formula in excel 2007. Please help. -- Thank you. You are awesome!
|
|
#6
March 11th, 2009, 03:46 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Excel Percentage
You're quite welcome!
-- Biff Microsoft Excel MVP "S" wrote in message ... Thank you! Thank you! -- Thank you. You are awesome! "T. Valko" wrote: Just divide: A1 = 66 B1 = 500 =A1/B1 Format as Percentage 66 is 13.2% of 500 -- Biff Microsoft Excel MVP "S" wrote in message ... Hi Sheeloo Please allow me to re-explain. I have three categories that should total to $500.00 and I additionally need to show these values as percentages. Category A is $66.00 (now I need to show $66.00 in the percentage phase is X% of the $500.00). So in the end, I am attempting to show the breakdown in the percentage value for each of the categories. I hope that I explained what I need to both of our understanding. Thank you again. -- Thank you. You are awesome! "S" wrote: I am drawing a blank. I am developing a comprehensive budget and am required to show the percentage for each of the expenditures. In the end, the percentages should total to 100. Example, $66.00 out of $100.00 = 20% $44.00 out of $100.00 = 10% $33.00 out of $100.00 = 90% I do not remember how to put formulate the formula in excel 2007. Please help. -- Thank you. You are awesome!
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
