kingconsto
New Member
- Joined
- Apr 19, 2017
- Messages
- 32
Hello,
I am trying to get an excel formula that will do linear interpolation for me. The data is set up as follows.
<colgroup><col width="83" style="width: 62pt; mso-width-source: userset; mso-width-alt: 3035;" span="2">
<tbody>
</tbody>
I am trying to get an excel formula that will do linear interpolation for me. The data is set up as follows.
1W | 0.24 |
1M | 0.26 |
2M | 0.27 |
3M | 0.31 |
6M | 0.32 |
9M | 0.34 |
1Y | 0.35 |
2Y | 0.41 |
3Y | 0.48 |
4Y | 0.56 |
5Y | 0.64 |
10Y | 1.02 How do I set it up to get the in between times such as what is the answer for 3.5M or 3.5Y . |