Hi,
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>
I have applied some simple calculations againist EMI 2. I need that calculation only if if enter numbers in the amount column. Is there any possibility
No | Date | Amount | Interest | Principal amount | Loan Balance |
EMI 1 | 13-Nov | 1230 | 343.75 | 886.25 | 24113.75 |
EMI 2 | =K5*16.5%/12 | =H6-I6 | =K5-J6 | ||
EMI 3 | 336.12 | -336.12 | 24781.44 | ||
EMI 4 | 340.74 | -340.74 | 25122.18 | ||
EMI 5 | 345.43 | -345.43 | 25467.61 | ||
EMI 6 | 350.18 | -350.18 | 25817.79 |
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>
I have applied some simple calculations againist EMI 2. I need that calculation only if if enter numbers in the amount column. Is there any possibility