Percentage Calculations Help

[Percentage Confusion]

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!

 

[Per Jessen]

Hi

A1 = 100, in B1:C1 enter =A1*.4, and in D1:E1 enter A1*.1

regards,
Per

"Percentage Confusion" <Percentage (e-mail address removed)>
skrev i meddelelsen
news:[email protected]...

 

[PA]

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

 

[Gord Dibben]

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