ExcelTip.com
Account Icon Account Icon Account Icon
ExcelTip.com

Go Back   Excel Help Forum > Usenet Groups > Excel Miscellaneous
Divide a given value into several cells [SOLVED] Divide a given value into several cells
Register FAQ Forum Rules Members List Calendar Search Today's Posts Mark Forums Read

Notices
Hi All,
The big green guy here, just wanted to let you all know that we now have the reputation system in place, the reputation system allows you to give a visible pat on the back to those that have helped you or whose information has been helpful.

You will see an icon in every post (Light Blue scales), click this to give the reputation point to whom you think deserves it, a green square appears for a reputation with more and more adding over time.Pretty soon you will see a string of green squares appear in the top right of your posts as your reputation grows and your forum presence!

Good Luck!
The Hulkster!

Reply
 
Thread Tools Search this Thread Rate Thread Display Modes
  #1  
Old 10-10-2008, 10:32 PM
REHNGA REHNGA is offline
Registered User
  
Join Date: 10 Oct 2008
Location: USA
Posts: 2
REHNGA is on a distinguished road
Divide a given value into several cells
If I have a value of lets say 53, I need it broken down into equal and whole numbers across the spread sheet with the last one being the remaining value.

Currently for example in cell F5 I have a value of 41 that I need to break down so I have done the following:
In Cell P5 =IF(F5>=25,F5-21,F5)
Then in Cell Z5 =IF(P5>=25,P5-21,P5) and this goes on until I have zero value from the original value in the last cell can i not do this all in one formula and have the results populate in other cells.

Thank you for any help you can provide
Last edited by REHNGA; 10-11-2008 at 10:28 AM. Reason: Solved
Reply With Quote
  #2  
Old 10-11-2008, 01:06 AM
dyazdani dyazdani is offline
Registered User
  
Join Date: 11 Oct 2008
Location: Baton Rouge
Posts: 1
dyazdani is on a distinguished road
Do you need to specify how many cells to take up? In other words, you could split up 41 either into "10 10 10 10 1" or "5 5 5 5 5 5 5 5 1"
Reply With Quote
  #3  
Old 10-11-2008, 01:28 AM
pjoaquin's Avatar
pjoaquin pjoaquin is offline
Forum Moderator
  
Join Date: 05 Feb 2007
Location: Wisconsin, U.S.A.
Posts: 2,328
pjoaquin will become famous soon enough pjoaquin will become famous soon enough
Rehnga, formulas cannot populate other cells, only the cell they are in. You could use a macro to do your calculations and insert the appropriate values in your cells without using formulas, though.
__________________
- Paul

Click here to read the Forum Rules

Reply With Quote
  #4  
Old 10-11-2008, 09:23 AM
REHNGA REHNGA is offline
Registered User
  
Join Date: 10 Oct 2008
Location: USA
Posts: 2
REHNGA is on a distinguished road
No I have no limit on the number of cells but it seems my question has been answered as Paul has pointed out formula will not populate other cells only the one it is in.
Thus it seems I will need to go to VBA for this, a macro will be OK for only one instance not multiple divide if I am thinking right.
Thank you for your input
Reply With Quote
Reply

Bookmarks

New topics in Excel Miscellaneous

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Linear Mode Linear Mode
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Count including Blank Cells bhofsetz Excel Worksheet Functions 10 02-27-2008 05:47 PM
Averaging non continuous cells, and ignoring cells with errors bog3494 Excel Worksheet Functions 3 02-27-2008 02:06 PM
Adding adjacent cells when value of cells is the same mike d Excel Worksheet Functions 1 02-15-2008 05:45 AM
Macro to Lock cells in protected sheet depending on criteria Zyphon Excel Programming 15 01-30-2008 12:00 PM
Counting occurence of multiple cells containing data BrakZak Excel General 8 11-08-2007 09:52 AM


All times are GMT -4. The time now is 05:48 PM.

Contact Us - ExcelTip.com - Archive - Top

Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0