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.
 
Top