Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Calculate the Interest rate
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Calculate the Interest rate
Bump
"Hardeep_kanwar" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Calculate the Interest rate
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. "Hardeep_kanwar" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculate weighted average effective interest rate | Excel Worksheet Functions | |||
Calculate interest rate on long term investment | Excel Worksheet Functions | |||
to compute interest rate from principal and interest amount | Excel Discussion (Misc queries) | |||
Calculate Interest Rate when payment changes! | Excel Worksheet Functions | |||
calculate interest on an increasing balance with variable rate | Excel Discussion (Misc queries) |