| View previous topic :: View next topic |
| Author |
Message |
jcooper
Newbie
Joined: 29 Jan 2005
Posts: 1
|
 Posted: Sat Jan 29, 2005 9:23 am Post subject: cash flow spread sheet |
 |
|
I am attempting to construct a cash flow spread sheet. I need a formula similar to the excel if/then formula. Spread sheet is constructed as thus:
Column B is the base line receivable or payable.
column C is the week one amount projected/actual.
column D is the week two projected/actual.
etc.
I need a formula that will take the base line amount of a payable (say $1) and if the entry for column C is $0, rather than the -$1 payable due, then it will add the $1 payable that was not paid in week one to the payable due in week two column D so that column D will read -$2.00 rather than the -$1 due in week two, and so on.
Please advise |
|
| Back to top |
|
 |
David
Super User
Joined: 24 Oct 2003
Posts: 5668
Location: Canada
|
| Posted: Sat Jan 29, 2005 1:29 pm Post subject: Re: cash flow spread sheet |
|
|
| jcooper wrote: | I am attempting to construct a cash flow spread sheet. I need a formula similar to the excel if/then formula. Spread sheet is constructed as thus:
Column B is the base line receivable or payable.
column C is the week one amount projected/actual.
column D is the week two projected/actual.
etc.
I need a formula that will take the base line amount of a payable (say $1) and if the entry for column C is $0, rather than the -$1 payable due, then it will add the $1 payable that was not paid in week one to the payable due in week two column D so that column D will read -$2.00 rather than the -$1 due in week two, and so on.
Please advise |
J... You might try posting this in the Calc conference instead of here. I'm no accountant/bookkeeper, but if you could give a few more sample row calculations for my enlightenement I'd give it a whack ...in the other conference. There you'll find others much more informed than I am to possibly give better advice.
David. |
|
| Back to top |
|
|
|
