formula for forward cover

JV0710

Active Member
Joined
Oct 26, 2006
Messages
358
Book1
ABCDEFGHI
1Sorryaboutthepreviouspostfolks,IjusttriedtheHTMLmakerforthefirsttime...
2Iwouldappreciateanyhelponthisquery
3
4Seebelow:
5
6Example
7ABCDEFGH
81DecemberJanuaryFebruaryMarchAprilMayJune
92MonthlyPayment200350300300350400
103
114Moneyavailableatendofmonth1000
125
136CoverinMonths3.5
14
15Question:
16InB6-Ineedaformulatoworkoutthatthe"moneyavailable"willlastonly3.5Months??
17(January,February,MarchandhalfofApril)
18
19Thanks
20
21Joe
Sheet1
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

JV0710

Active Member
Joined
Oct 26, 2006
Messages
358
Hi Neil - yes it is, My apologies . . . My Assistant was at my desk and "Re-sent".

I have posted comments on your answer this morning, on the previous post - Once again I apologise
 

Watch MrExcel Video

Forum statistics

Threads
1,113,793
Messages
5,544,315
Members
410,602
Latest member
lidovi
Top