How to Calculate the Interest rate

H

Hardeep_kanwar

Could any one Please tell me what Formula i Can Use to Calculate the Interest
Rate for a Days, Months,6Months, and a year

A2=6292
A3=5%
A4=10Days
A5=1MONTH
A6=6 MONTH
A7=1 YEAR

Now In B2 i want to Calculate the Interest of 10 Days @5%
B3 Interest of 1 Month @5%
B4 Interest of 6 Month@5%
B5 Interest of 1 Year@5%

Thanks in Advance
 
F

Fred Smith

The subject of your post says you want to calculate the interest rate, but
the body says you want to calculate the interest amount. Assuming the body
is correct, you want:

=a2*a3*a4/365
=a2*a3*a5/365
=a2*a3*a6/365
=a2*a3*a7/365

This assumes that a4 through a7 are the number of days in the period.

Regards,
Fred.

PS. Bumping your post won't get you any quicker help. Clear questions will.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top