RANREV INFOTECH PMT,PPMT,IPMT EXCEL PART 2
Author: Sanskriti
TOTAL AMOUNT (CELL ADD PHONE - DOWN PAY)
EMI =PMT(CELL ADD RATE/12,CELL ADD TIME/12, CELL ADD TOTAL AMOUNT)
=PPMT(CELL ADD RATE LOCK BY F4/12,MONTH CELL ADD,CELL ADD TIME LOCK BY F4,CELL ADD TOTAL AMOUNT LOCK BY F4)
=IPMT(CELL ADD RATE LOCK BY F4/12,MONTH CELL ADD,CELL ADD TIME LOCK BY F4,CELL ADD TOTAL AMOUNT LOCK BY F4)
