To calculate compound interest half-yearly, we have to multiply n by 2 and divide the rate by 2. Compounded quarterly: Every year has four quarters.

Enter the present value in an Excel spreadsheet cell in place of "PV," which is your starting amount before compounding. Enter the interest rate in place of "R." ...