writer
6,694
edits
Changes
no edit summary
*<math>CashFlowEvents</math> is the array of values.
*<math>CashFlowEvents</math> is the array of values.
*<math>StartGuess</math> is the number is close to the result of IRR.
*<math>StartGuess</math> is the number is close to the result of IRR.
*<math>Accuracy</math> is the correct of decimal places of the result.
*<math>NoOfIterations</math> is the number of iterations.
==Description==
==Description==
*<math>IRR</math> is similar to the net present value calculation.
*<math>IRR</math> is similar to the net present value calculation.
*In <math>IRR (CashFlowEvents,StartGuess,Accuracy,NoOfIterations)</math>,<math>CashFlowEvents</math> is an values which is the array or a reference to cells that contain numbers for which you want to calculate the internal rate of return.
*In <math>IRR (CashFlowEvents,StartGuess,Accuracy,NoOfIterations)</math>,<math>CashFlowEvents</math> is an values which is the array or a reference to cells that contain numbers for which you want to calculate the internal rate of return.
*<math>g</math> is the guess which is indicating the number that you guess is close to the result of <math>IRR</math>.
*<math>StartGuess</math> is the guess which is indicating the number that you guess is close to the result of <math>IRR</math>.
*<math>CashFlowEvents</math> must have atleast one positive and one negative value to find the internal rate of return.
*<math>CashFlowEvents</math> must have atleast one positive and one negative value to find the internal rate of return.
*The value of <math>CashFlowEvents</math> can be array or reference argument contains text, logical values or empty cells, the values which are ignored.
*The value of <math>CashFlowEvents</math> can be array or reference argument contains text, logical values or empty cells, the values which are ignored.