Re: $$Excel-Macros$$ No Body reply --- Interest calculation as per we put years in -- D3 -- Can anybody help me out

Your workbook will not be correct.What you're trying to do is called"Simple Interest Loan Amortization". Or in your case, it's an INVESTMENT amortization. The problem is, the interest on loans or investments are "compounded".That is, that the interest is calculated monthly based on the current

Re: $$Excel-Macros$$ No Body reply --- Interest calculation as per we put years in -- D3 -- Can anybody help me out

Thanks Paulji 1] Your idea is really very good . But my query is i want to calculate yearly basis& not monthly basis. 2] The same way what u have done is I want yearly basis. Had u use any macro or just formula only .. Thanks a lot . On 11 February 2016 at 19:03, Paul Schreiner

$$Excel-Macros$$ No Body reply --- Interest calculation as per we put years in -- D3 -- Can anybody help me out

Dear All Friends No body reply On 10 February 2016 at 09:48, big smile wrote: > Respected All , > > Can anybody Help me out for this query. > > On 9 February 2016 at 12:36, big smile wrote: > >> Respected All, >> >> Can i have solution for this my