Start by calculating the interest using the simple interest formula. This includes the amount of money you will be investing or saving. Loan Amount in dollars and cents x Interest Rate x Time in days Total Interest You must select the values to enter the.
A P1 rt where P is the Principal amount of money to be invested at an Interest Rate R per period for t Number of Time Periods.
10 100. Next click on More Functions and point the cursor on Statistical. In order to do a simple interest calculation in Excel using the COUNTA function follow the procedure below. A P1 rt where P is the Principal amount of money to be invested at an Interest Rate R per period for t Number of Time Periods.