help

[bev]

Not sure what your help is about but I am unable to log a new question so
thought I would use yours.

I am trying to set up a cash flow statement.
I have 3 sheets,
1st summery page with cash flow on (this will get the information from sheet
2)
2nd is a split of all the accounts and the cash flows in the accounts for
the month (this page gets the information from the 3rd sheet)
This is where I have the problem.
On the 3rd sheet I have all the detail of the transitions.
The problem is that I want to be able to enter costs say subs as - the
amount, date start and the frequency of the payments (so quarterly/ 3monthly).

So what I need is a formula in the second sheet that can look at the about
information (in 3rd sheet) and see if it is due in the month and what the
amount is.

Now this may not be the easiest way to do this, if you have any suggestions
please feel free to let me know.
If you are able to help with the formula please do.

Thank

 

[Roger Govier]

Hi Bev

Assuming sheet 2 has the following values in B1:M1
01/01/07, 01/02/07, ...... 01/12/07 with the cell formatted as mmm to show
Jan, Feb Mar etc.
Also, Sheet3 has
A1 Description, B1 Amount, C1 Date, D1 Frequency
with values from A2 onward.

On sheet2 cell B2 enter
=IF(MOD(MONTH(Sheet3!$C2),Sheet3!$D2)=
MOD(MONTH(Sheet2!B$1),Sheet3!$D2),Sheet3!$B2,0)

copy across through C2:M2 then copy the whole of B2:M2 down as afar as
required.