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!