Home |
Search |
Today's Posts |
#1
|
|||
|
|||
INTRATE function
Exactly what interest rate does this function return? Is it compounded, simple, and what is the purpose of the "basis"?
|
#2
|
|||
|
|||
Use the Function Wizard to enter the function and click on "Help on this
function" It tells you all about it -- Kind regards, Niek Otten Microsoft MVP - Excel "gfoster07k" wrote in message ... Exactly what interest rate does this function return? Is it compounded, simple, and what is the purpose of the "basis"? -- gfoster07k |
#3
|
|||
|
|||
Since there were several viewers and no responses, I am posting the answer I found for general interest. The interest rate returned is simple interest per year with no compounding. The equation is (total interest earned)/(investment x fractional years invested). Example: $1000/($10,000 x 1.5yrs) = 6.67% per year.
Quote:
|
#4
|
|||
|
|||
What do you mean, no responses?
-- Kind regards, Niek Otten Microsoft MVP - Excel "gfoster07k" wrote in message ... Since there were several viewers and no responses, I am posting the answer I found for general interest. The interest rate returned is simple interest per year with no compounding. The equation is (total interest earned)/(investment x fractional years invested). Example: $1000/($10,000 x 1.5yrs) = 6.67% per year. gfoster07k Wrote: Exactly what interest rate does this function return? -- gfoster07k |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions |