Function to Spread Costs

A

andyhofer

Is there a function that will spread a value across other values based
on that value. Example below :

Original Value
Week1 100
Week2 200
Week3 400
Total 700

Value to spread across the 3 weeks 350
The 350 split would give
Week1 50
Week2 100
Week3 200
Total 350

Therefore new value would be
Week1 150
Week2 300
Week3 600
Total 1050

Hope that's clear
 
B

bj

It looks like you want to have the split such that each week gets twice the
value of the previous week
if spl is the total to be split
and ns is the number of weeks
if it starts on row one and the original data is in column a
try
in B2
=A1+spl*max(1,(row()-1)*2)/(ns^2-1)
and copy down
 

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


Top