To calculate the EMI, enter the formula using theABSandPMTfunctions. =ABS(PMT($I$7,$I$6,$F$5,0,0)) PressEnterto apply the formula. You need to have the same EMI for every value. So, if you look at the formula, you will find all the cells are made constant by using the($)...
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 ...
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=...