Hi All,
So I'm trying to do a budget cash flow for my future pipeline of works.
What I have is a tab with the details what I have quoted with a start month, duration and likely hood (as a %) what I want to do, is make it generate a cashflow by month so I have put "Jan" "Feb" etc across and i want it to look at the likely hood, if over 70% i want it to then look at the start month and duration, then take the value and split it across the months in the cash flow, is there a formula for doing this? I've attached an example.
Thanks in advance!
Dave
Bookmarks