kumara_faith
Well-known Member
- Joined
- Aug 19, 2006
- Messages
- 951
- Office Version
- 365
Hi,
I have the following table:
I would like to populate the values in column E, I and J to column J according to value in cell C11. In other words, since cell C11 only has a value of 5, then the values in column E, I and J should only populate up to year 5. Is there a way to do this ? Appreciate all the help.
I have the following table:
| Book2 | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| B | C | D | E | F | G | H | I | J | |||
| 4 | Maturity Period | 5 | Year | Face Value | Initial | Face Value-Bond Price | Interest | Total | |||
| 5 | Coupon Rate | 6% | 1 | 1000 | 950 | 50 | 60 | 1060 | |||
| 6 | Frequency of Coupon | 1.00 | 2 | 60 | 1120 | ||||||
| 7 | Current Bond Price | 950 | 3 | 60 | 1180 | ||||||
| 8 | Face Value | 1000 | 4 | 60 | 1240 | ||||||
| 9 | 5 | 60 | 1300 | ||||||||
| 10 | Adjusted Coupon Payment | 60 | |||||||||
| 11 | Adjusted No of Period | 5 | |||||||||
Bond | |||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| G5 | G5 | =C7 |
| H5 | H5 | =F5-G5 |
| I5:I9 | I5 | =$C$10*$C$6 |
| J5 | J5 | =G5+I5+H5 |
| J6:J9 | J6 | =J5+I6 |
| C10 | C10 | =IF(C6>0,C5*C8/C6,C5*C8) |
| C11 | C11 | =IF(C6>0,C4*C6,C4) |
I would like to populate the values in column E, I and J to column J according to value in cell C11. In other words, since cell C11 only has a value of 5, then the values in column E, I and J should only populate up to year 5. Is there a way to do this ? Appreciate all the help.
