|
Posted to microsoft.public.excel.misc
|
|
|
breaking down a whole number into pre-defined parts..
Thanks to you both
"MartinW" wrote:
Hi GD,
You may want to take a look here at John McGimpsey's site.
You should be able to adapt his methods to your needs.
http://www.mcgimpsey.com/excel/variablerate.html
HTH
Martin
"GD" wrote in message
...
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
|