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!