| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
requesting formula for distributing a number
Hi,
Is there a way to distribute a large number? Basically, I want to be able to plug "X" where X could be any postive integer into B1 and have excel automatically distribute it such that the first 15 of X go into B2 and the next 5 into B3 and the next 5 into B4 and all additional into B5, but if X is only 5, then B1 would be 5 and B3 through B5 would all be 0. Or if X is 17 then B2 would be 15 and B3 would be 2 and B4 and B5 would both be 0. Is this possible? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup Data in two seperate Spreadsheets | Excel Worksheet Functions | |||
| Vlookup to Return a Range of Data | Excel Discussion (Misc queries) | |||
| If formula | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Threaded Mode
