Hi All,
I m working on MS Office 2010,
I am making a 'Half yearly Interest Calculating Excel page'
I've created a Rough Page , which is attached herewith,
What I need is in Cell G2 Interest+Principal
of A2 @ B2% From C2 to D2 days [ie E2] (Calculated Half yearly ie 180 days)
The final figure will be 151.62 for 5 years
Please help
=FV(B2%/2,INT(E2/180)*2,0,-A2)
Note that 1080 days is 6 years.
Pauley
--------
If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).
=FV(B2%/2,INT(E2/180)*2,0,-A2)
Note that 1080 days is 6 years.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks