Monthly Spreading remaining values between two dates

tamill35

New Member
Joined
Dec 8, 2006
Messages
1
The formula works good for linear spreading values in each month between two dates =IF(AX$2<$AE3,0,IF(AX$2>$AF3,$AU3,((AX$2-MAX($AE3,$AW$1)+1)/$AV3)*$AU3)) where AX2 is monthly cut off date, AE is start date, A4 is End date, AU is value to be spread, AW1 is current date after which remaining values are to be distributed.

My questions are:-
1) This formula gives linear spreading for each month. Is there a way to spread non linear such as Back loaded distribution eg 3.5% for first 10 steps, then 6.5% for remaining 10 steps
2) I tried to summarise a range by the formula =SUMPRODUCT(IF(AX$2<($AE3:$AE384),0,IF(AX$2>($AF3:$AF384),($AU3:$AU384),((AX$2-MAX(($AE3:$AE384),$AW$1)+1))/($AV3:$AV384))*($AU3:$AU384))) But the formula is not giving the correct value. I dont understand what mistake I have done.

Can somebody help.

Thanks,
Selvam
 

Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Watch MrExcel Video

Forum statistics

Threads
1,095,728
Messages
5,446,172
Members
405,388
Latest member
Arlind

This Week's Hot Topics

Top