Enter the loan amount in a cell
Enter the annual interest rate in a cell
Enter the loan tenure in years or months in a cell
Convert the annual interest rate to monthly rate by dividing by 12
Convert the tenure to total number of months
Use the formula `=PMT(rate/12, tenure_months, -loan_amount)` if the rate is annual
Use the formula `=PMT(monthly_rate, tenure_months, -loan_amount)` if the monthly rate is already available
Replace `rate/12` with the cell reference containing the monthly interest rate
Replace `tenure_months` with the cell reference containing the total months
Replace `loan_amount` with the cell reference containing the principal amount
Press Enter to get the EMI value
Use absolute cell references if copying the formula across rows
Format the EMI cell as currency or number if needed