Excel query on a cash flow sheet

Microsoft Office excel 2007 home & stude...
August 16, 2010 at 14:55:10
Specs: Macintosh
I have the following headings on a spreadsheet that is to follow cash flow -
Column F is the rate
Column I is 25% deposit of the rate in F
Column N is total extras
Column O is Balance amount
Column P is date balance received
Column Q is total revenue

I firstly asked the question of how to include a formula so that Column O gave a negative amount if a date wasn't put in column P.
The problem I now have is the total revenue is taking these negative figures into account and not giving a true total revenue running reading.
The second problem is the total revenue is taking into account the negative balance amount in column O, even if a deposit has been paid?
Is there a formula to rectify this problem?
Any help greatly received, or a further explanation can be given,

Regards, Ian

See More: Excel query on a cash flow sheet

August 17, 2010 at 05:04:01

Column Q on each row can use this formula to show zero if no balance paid or to show the balance paid once the column P cell (date balance received) has been completed:

To total column O (balance amount) for all rows use this:
(adjust row numbers as appropriate)
This only sums positive amounts.

To find total of outstanding balances use this:
This only sums negative amounts

(I am assuming that the amount in column O changes from negative to positive when column P is completed).


Report •
Related Solutions

Ask Question