Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Function to Spread Costs
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to Spread Costs
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 "andyhofer" wrote: 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 -- andyhofer |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i enter a bull call spread into the options spread sheet ? | Excel Worksheet Functions | |||
COMPARE CURRENT MORTAGAGE COSTS TO NEW MORTAGAGE COSTS | Excel Discussion (Misc queries) | |||
COMPARE CURRENT MORTAGAGE COSTS TO NEW MORTAGAGE COSTS | Excel Discussion (Misc queries) | |||
Idea for an Excel function called "Spread" | Excel Worksheet Functions | |||
Is there a spread sheet for tracking construction costs and draws. | Excel Discussion (Misc queries) |