# if statements

##### Board Regular
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

### Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

#### Peter_SSs

##### MrExcel MVP, Moderator
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
ABCDEFGHIJKL
190258416100647769489538
2
6
7
856436983
9
10
18
19
2052.7549.572.587.259167.257563.7538.258
21
Sheet1

##### Board Regular
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..

Replies
1
Views
279
Replies
4
Views
460
Replies
10
Views
253
Replies
4
Views
240
Replies
0
Views
356

1,190,631
Messages
5,982,031
Members
439,750
Latest member
megaman777

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back