writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 8:
Line 8: − INTRATE() calculates the interest rate per period for a year.+ Line 16:
Line 16: − **<math>FutureValue</math>, *<math>Type</math> and *<math>Guess</math> are optional.+
no edit summary
*<math>Guess</math> is the guess value for what rate will be
*<math>Guess</math> is the guess value for what rate will be
RATE() calculates the interest rate per period for a year.
== Description ==
== Description ==
*RATE is calculated by iteration and can have zero or more solutions.
*RATE is calculated by iteration and can have zero or more solutions.
*<math>Payment</math> includes principal value and the interest amount. If omitted, <math>FutureValue</math> is required.
*<math>Payment</math> includes principal value and the interest amount. If omitted, <math>FutureValue</math> is required.
*<math>FutureValue</math>, <math>Type</math> and <math>Guess</math> are optional.
*If <math>FutureValue</math> is omitted, Calci assumes it to be zero(0).
*If <math>FutureValue</math> is omitted, Calci assumes it to be zero(0).
*<math>Type</math> can be represented as '1' or '0'.
*<math>Type</math> can be represented as '1' or '0'.