how to divide the number in one cell into multiple cells

R

Ramya

I have a value (5000) in one Excel cell. I need to distribute it into equal
values in 10 cells. Can any one please let me know how to do that
 
J

Jacob Skaria

Suppose you have 5000 in cell A1 and your target cells are B1:B10.

Select B1:B10. Keeping the selection of 10 cells press = to enter a formula

=A1/10

Instead of enter press Ctrl+Shift+Enter...Now try changing the value in A1

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Divide the total in one cell into up to 6 others 6
How to divide the each digit of the phone numbers into different c 3
Divide by the minimum non-zero number in a range of cells 21
Variable calculation question 1
How to equal a cell in another worksheet incl fill colour 3
Consolidate multiple cells into one 1
I need to add multiple cells then subtract them from one cell c4+c6+c7+c9+c10+c11 and subtract them 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0

Top