Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with IRR function
I am attempting to use the IRR function with a series of 121 payments. The
first is positive, and all others are negative. When entering the function, the result displays as #NUM! I rechecked, and all are numbers. What's going on. I've pasted the numbers below for anyone who would like to try this. Note that the first payment is larger than the others. The first part of the series, 10,000, -309, -175 is as intended. I wonder what is going on, and how I can make this work. Thanks very much. 10,000 -309 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 -175 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with IRR function
Hi Keith,
If you supply a guess of 2% as the second argument to the IRR you'll probably get the right answer -- Kind regards, Niek Otten Microsoft MVP - Excel "Keith" wrote in message ... |I am attempting to use the IRR function with a series of 121 payments. The | first is positive, and all others are negative. When entering the function, | the result displays as #NUM! I rechecked, and all are numbers. What's going | on. | | I've pasted the numbers below for anyone who would like to try this. Note | that the first payment is larger than the others. The first part of the | series, | 10,000, -309, -175 is as intended. | | I wonder what is going on, and how I can make this work. | | Thanks very much. | | 10,000 | -309 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with IRR function
Hi Niek,
thanks very much. Keith "Niek Otten" wrote: Hi Keith, If you supply a guess of 2% as the second argument to the IRR you'll probably get the right answer -- Kind regards, Niek Otten Microsoft MVP - Excel "Keith" wrote in message ... |I am attempting to use the IRR function with a series of 121 payments. The | first is positive, and all others are negative. When entering the function, | the result displays as #NUM! I rechecked, and all are numbers. What's going | on. | | I've pasted the numbers below for anyone who would like to try this. Note | that the first payment is larger than the others. The first part of the | series, | 10,000, -309, -175 is as intended. | | I wonder what is going on, and how I can make this work. | | Thanks very much. | | 10,000 | -309 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | -175 | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mid Function Problem | Excel Discussion (Misc queries) | |||
if Function problem | Excel Discussion (Misc queries) | |||
Problem with the VALUE function | Excel Discussion (Misc queries) | |||
FV Function Problem | Excel Worksheet Functions | |||
IF function problem | Excel Worksheet Functions |