| Home |
| Search |
| Today's Posts |
|
#1
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
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
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
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
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
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Percentage formula in excel | Excel Worksheet Functions | |||
| Excel - calculating a percentage | Excel Discussion (Misc queries) | |||
| Calculating a percentage with the end percentage in mind | Excel Discussion (Misc queries) | |||
| Percentage increase in excel | Excel Discussion (Misc queries) | |||
| how do I up a percentage formual in excel | Excel Discussion (Misc queries) | |||
Linear Mode
