Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
breaking down a whole number into pre-defined parts..
Hey, i've got an issue whereby a total stock figure, in terms of pricing how
much to paid for storage, needs to be broken down. If for example in Cell A1 is the figure 247,000 and the weighting is the first 100,000 is priced at 10p per tonne, the second 100,000 at 7p per tonne, the 3rd 100,000 at 5 pr tonne and so-on. What i'm looking for is a formula of sorts that can go in three cells to separate the 247,000 into a 100,000, a 100,000 and a 47,00...if you get what I mean? Otherwise it means having to manually key the figures into pre-defined cells to make the calculation run, it would be really handy if there was function to do it automatically |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding number parts by cell formatting | Excel Discussion (Misc queries) | |||
Split a number in a cell into parts | Excel Discussion (Misc queries) | |||
Insert Row by a defined Number | Excel Discussion (Misc queries) | |||
breaking up a phone number | Excel Worksheet Functions | |||
breaking up a phone number | Excel Discussion (Misc queries) |