Monthly Installment Calculation

An Excel file that teaches how to perform Monthly Installment Calculation operation.

Excel Spreadsheet for Monthly Installment Calculation

Search parameters are taken from separate cells. The FIND and MATCH functions are used together. The results list is dynamically generated. Partial matches are highlighted in color. A quick filter field is included.

Hope it is useful.