Press Enter to apply the formula. You need to have the same EMI for every value. Find all the cells that are made constant by using the ($) sign. Drag the Fill Handle icon down the column to cell C17. Our EMI for that specific loan amount and interest rate. Method 2 – Estimate ...
To calculate the EMI, enter the conventional formula in the formula box. =$I$4*$I$5/12*(1+$I$5/12)^$I$6/((1+$I$5/12)^$I$6-1) Press Enter to apply the formula. The most important thing to remember is that you need to have the same EMI for every value. If you look ...
In cellG11, insert the formula: =IFERROR(IF(B11="","",D11-E11),"") PressEnter. This formula calculates theending balanceafter paying the EMI for the respective month. The result will be blank initially due to zero or blank cell references. Breakdown of the Formula =IFERROR(IF(B11=...