98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Cashflows
Cashflows
Resolved · Urgent Priority · Version 2007
Wed 8 Jun 2011, 16:44Delegate Greg said...
Greg has attended:
Excel Intermediate course
Excel Advanced course
Cashflows
i want to show on the first row the amount of funds committed to a project. the next row below will show the funds being spent. so there is alage between the two. how do i arrange for the lag to be made automatically ?
Thu 9 Jun 2011, 10:14Trainer Stephen said...
RE: cashflows
Hi Greg,
Thanks for your question
Could you elaborate on your requirements for me? You say you have two values funds committed and funds spent and that there will be a difference between the two (Lag). You wish to be able to set the lag automatically to a predetermined value. This can be done by altering the projected funds or the actual spend.
Which one do you wish to vary?
Thanks
Stephen
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Shortcut for deleting all comments in a spreadsheetIf you have entered multiple comments into a spreadsheet and wish to delete them all at once, you can achieve this by: |
