| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Percentage Calculations Help
I have a sheet that I created with a whole number and I need to divide it in
4 different cells. For example: I have a number 100 in one cell. In four different cells after that I need to divide that number by 40%, 40%, 10% and 10%. How do I do that? So after dividing it by this percentage I should have nothing left over. Thank you so much! |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Percentage Calculations Help
Hi
A1 = 100, in B1:C1 enter =A1*.4, and in D1:E1 enter A1*.1 regards, Per "Percentage Confusion" <Percentage skrev i meddelelsen ... I have a sheet that I created with a whole number and I need to divide it in 4 different cells. For example: I have a number 100 in one cell. In four different cells after that I need to divide that number by 40%, 40%, 10% and 10%. How do I do that? So after dividing it by this percentage I should have nothing left over. Thank you so much! |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Percentage Calculations Help
If the number of interest is in A1, then in
B1 put the formula, =a1*.4 C1 put the formula, =a1*.4 D1 put the formula, =a1*.1 E1 put the formula, =a1*.1 If 100 is in A1, then the results will be 40,40,10,10 "Percentage Confusion" wrote: I have a sheet that I created with a whole number and I need to divide it in 4 different cells. For example: I have a number 100 in one cell. In four different cells after that I need to divide that number by 40%, 40%, 10% and 10%. How do I do that? So after dividing it by this percentage I should have nothing left over. Thank you so much! |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Percentage Calculations Help
Just a note to OP
PA's suggestion is correct but the 100 in A1 will not reduce to 0 if that's what you meant by "nothing left over". Gord Dibben MS Excel MVP On Wed, 9 Jul 2008 11:06:00 -0700, PA wrote: If the number of interest is in A1, then in B1 put the formula, =a1*.4 C1 put the formula, =a1*.4 D1 put the formula, =a1*.1 E1 put the formula, =a1*.1 If 100 is in A1, then the results will be 40,40,10,10 "Percentage Confusion" wrote: I have a sheet that I created with a whole number and I need to divide it in 4 different cells. For example: I have a number 100 in one cell. In four different cells after that I need to divide that number by 40%, 40%, 10% and 10%. How do I do that? So after dividing it by this percentage I should have nothing left over. Thank you so much! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Percentage calculations | New Users to Excel | |||
| Percentage calculations from an unsorted two column list | Excel Discussion (Misc queries) | |||
| Calculating a percentage with the end percentage in mind | Excel Discussion (Misc queries) | |||
| Bar Chart depicting the "percentage of another percentage(less than 100)" | Charts and Charting in Excel | |||
| Percentage Calculations | Excel Discussion (Misc queries) | |||
Linear Mode
