$$Excel-Macros$$ How to calculate interest

hi all, i have attached the excel sheet, pls give a dynamic way to calculate interst on the given conditions thanks niraj --~--~-~--~~~---~--~~ - Some important links for excel

$$Excel-Macros$$ Re: **ADD/Multiply/Subtract/Divide two Numbers**

Hi Paresh, The syntax is failry simple for what you want to do, but perhaps it would be easier done with a worksheet function. However, if you want do it by macro, the below is an example: Sub DoMath Answer1 = 4 + 5 Answer2 = 4 * 5 Answer3 = 4 - 5 Answer4 = 4 / 5 End Sub 'Answer1' , 'Answer2'