This formula is working 4 Step 1 for Yearly Compound Interest,2 Half Yearly Compound Interest, 3 is Quarterly Basis and 4th is Monthly basis. 4in1. This formula is very useful for Calculation of Banking Interest in Excel. This is for Example Sheet. This sheet is password protected sheet #xls