if statements

[ppleasebob]

I am trying to write a cashflow forecast based on estimated income which then adjusts with actual income when known, it's getting a little complicated but the basics are:

June cash = 75% of April actual + 25% of May actual
July cash = 75% of May actual + 25% of June actual
August cash = 75% of June actual + 25% of July estimated
Sept cash = 75% of July estimated + 25% of August estimated
and so on..

A1:L1 being jan to december estimated figures
A8:L8 being jan to december actual figures
a20:L20 being jan to december cashflow figures

I have different departments to deal with who all have differing payment delays, but a solution to the above would more than get me started.

Go Board....

Cheers
Bob

 

[Peter_SSs]

Bob

I assume the "actual" row is blank until figures become available. Not sure what you want with the first couple of months, but does this formula (copied across) help at all?

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L
1	90	25	84	16	100	64	77	69	48	9	5	38
2
6
7
8	56	43	69	83
9
10
18
19
20			52.75	49.5	72.5	87.25	91	67.25	75	63.75	38.25	8
21
Sheet1

 

[ppleasebob]

Peter,

thanks very much, you wouldn't believe how long I've been looking at this.. my mistake was to look for blanks first and then try the sum in one go across both conditions..