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 ?
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