We will use the FV excel formula to calculate compound interest. Type IPMT B2 1 B3 B1 into cell B4 and press Enter. Calculate simple interest Exceljet Skip to main content.
Here we have a data set and to get Simple interest SI amount.
The general formula for calculating simple interest in Excel is shown below. In our example the formula is A2 1B2 where A2 is your initial deposit and B2 is the annual interest rate. However in this example the interest is paid monthly. Here we have a data set and to get Simple interest SI amount.