Distribute value in series order
- Thread starter musthu
- Start date
Hello Musthu,
I am a bit confused what you want to achieve. Per the demo file I would think that you just multiply the salary with the percentages that you have listed, but I assume that it cannot be that simple. What exactly do you mean with "series order"? How have you determined the percentages in Row 14. Are the periods important?
I am a bit confused what you want to achieve. Per the demo file I would think that you just multiply the salary with the percentages that you have listed, but I assume that it cannot be that simple. What exactly do you mean with "series order"? How have you determined the percentages in Row 14. Are the periods important?
I would like to distribute the value over the period mentioned, The distribution should be low at the starting and ending stage and would be peak in the middle stages. The % mentioned is an eg: its not determined.only thing it should be as per the above mentioned
if the % is determined for each specific period in a separate rows (ie: for 1 month 100 %, for 2 -50% 50%, for 3- say20%,60%20% (its not specific only thing should be low at the starting and ending stage and would be peak in the middle stages) is there a way to pick it and multiply.
For the number of months can it pick the % determined in series order and allocate the value(see attached)
if the % is determined for each specific period in a separate rows (ie: for 1 month 100 %, for 2 -50% 50%, for 3- say20%,60%20% (its not specific only thing should be low at the starting and ending stage and would be peak in the middle stages) is there a way to pick it and multiply.
For the number of months can it pick the % determined in series order and allocate the value(see attached)
Yes, you can.
The key is the INDEX function that allows you to pick a value from an array of cells by specifying row and column. The row number is the number of months and the column number the difference in months between the month to calculate and the first month (plus one as the array count starts with one)
If you surround this with an If(MonthInRange;Calculate;0) command you have a universal formula for your problem. Have a look at the attached file for details.
The key is the INDEX function that allows you to pick a value from an array of cells by specifying row and column. The row number is the number of months and the column number the difference in months between the month to calculate and the first month (plus one as the array count starts with one)
If you surround this with an If(MonthInRange;Calculate;0) command you have a universal formula for your problem. Have a look at the attached file for details.
