John Caines
Well-known Member
- Joined
- Aug 28, 2006
- Messages
- 1,155
- Office Version
- 2019
- Platform
- Windows
Hello All.
I'm trying to figure out how to make a drawdown recovery calculator.
I've come up with the formatting, outline of the calculator,
and I've got an idea of what some of the formulas might be.
Trouble is I can't see how to enter the formulas into the spreadsheet properly.
I have a spreadsheet here in my dropbox;
https://www.dropbox.com/s/lg3opcaeugbycdo/Recovery-Calc.xlsx?dl=0
Image here
https://imgur.com/a/3U2QFtZ
I'm not to great with formulas,
I can't see how to imbed the formulas into the green filled cells to make this all work![Frown :-( :-(](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f641.png)
Hope someone can help me out here.
Really just can't work it out.
Maybe even a VB solution would be better?
but I think it can be done with just formulas
Many thanks in advance
John C
I'm trying to figure out how to make a drawdown recovery calculator.
I've come up with the formatting, outline of the calculator,
and I've got an idea of what some of the formulas might be.
Trouble is I can't see how to enter the formulas into the spreadsheet properly.
I have a spreadsheet here in my dropbox;
https://www.dropbox.com/s/lg3opcaeugbycdo/Recovery-Calc.xlsx?dl=0
Image here
https://imgur.com/a/3U2QFtZ
I'm not to great with formulas,
I can't see how to imbed the formulas into the green filled cells to make this all work
![Frown :-( :-(](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f641.png)
Hope someone can help me out here.
Really just can't work it out.
Maybe even a VB solution would be better?
but I think it can be done with just formulas
Many thanks in advance
John C