hw to give excel formula in excel sheet
for example if i want to calcutale interest for the following
| from | to | Amt | rate of interest | total Interest for days |
| January 4, 2009 | June 30, 2009 | 100,000.00 | 8% P A |
what formula i should set so that i can get the figure of total interest ( i dont want to count total days manully it shold be come in the formula also )
U better used the rate fnction in excel. For rounding use Round function in excel. All functions r available in insert menu. Also self explanatory exmples with all respective functions
Hi... Sumit I have attach here for your problem solution pls find. And further any quarry pls tell me. Regards Sagar Zankhariya
CAclubindia
