Hi there,
I'm having trouble changing the formula in row 7 so that I get the answers I've simply hard-coded in row 9. I don't want to show the percentages as they are calculating currently in row 7. Apologies that I have not used HTML Maker on the basis that I have recently upgraded to excel 2016 and have just tried to add it in, though I cannot see where I have the option to generate HTML.
Anyway, first things first, any assistance to my percentages formula would be appreciated.
<colgroup><col width="34" style="width: 26pt; mso-width-source: userset; mso-width-alt: 1243;">
<col width="64" style="width: 48pt;" span="7">
<tbody>
</tbody>
Regards
Ben
I'm having trouble changing the formula in row 7 so that I get the answers I've simply hard-coded in row 9. I don't want to show the percentages as they are calculating currently in row 7. Apologies that I have not used HTML Maker on the basis that I have recently upgraded to excel 2016 and have just tried to add it in, though I cannot see where I have the option to generate HTML.
Anyway, first things first, any assistance to my percentages formula would be appreciated.
| A | B | C | D | E | F | G | |
| 1 | |||||||
| 2 | RPI Close Future Fcst | Interest | |||||
| 3 | Scenario1 | 2.47% | 0.10% | ||||
| 4 | |||||||
| 5 | Start | Mar-17 | Mar-18 | Mar-19 | Mar-20 | Mar-21 | Mar-22 |
| 6 | |||||||
| 7 | 1 | 102.37% | 104.80% | 107.28% | 109.82% | 112.43% | 115.09% |
| 8 | |||||||
| 9 | 2.37% | 4.80% | 7.28% | 9.82% | 12.43% | 15.09% |
Regards
Ben
