how to divide the number in one cell into multiple cells

  • Thread starter Thread starter Ramya
  • Start date Start date
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
 
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

Red cell for negative numbers in Excel 1
Divide the total in one cell into up to 6 others 6
Divide two cells and if the number is negative display is as zero 2
How to divide the each digit of the phone numbers into different c 3
Need to separate multiple numbers in one cell 3
Excel Need Countifs Formula Help 0
resettable, over-ridable, default cell values 0
Divide by the minimum non-zero number in a range of cells 21

Back
Top