Forum Discussion
Solved
Help with #NUM error in IRR formula
In the attached image and file (See tab B&C, Cell B15,) I'm having difficulties with the IRR formula as it is displaying a #NUM error instead of a numerical value. What seems to be the issue here? ...
IRR requires at least one negative value (as initial cost of business), see at https://support.office.com/en-us/article/IRR-function-64925EAA-9988-495B-B290-3AD0C163C1BC
I have the same problem. please check the table and help me.
| cash flow | |||
| 1372000000000 | 1 | ||
| 0 | 2 | ||
| (77777777778) | 3 | ||
| (73009451097) | 4 | ||
| (68241124416) | 5 | ||
| (63472797735) | 6 | ||
| (58704471055) | 7 | ||
| (53936144374) | 8 | ||
| (49167817693) | 9 | ||
| (1416399491012) | 10 | ||
| (39631164332) | 11 | ||
| 42914940127 | 12 | ||
| 42914940127 | 13 | ||
| 42914940127 | 14 | ||
| 42914940127 | 15 | ||
| 40076609987 | 16 | ||
| 37238279847 | 17 | ||
| 34399949707 | 18 | ||
| 31561619568 | 19 | ||
| 28723289428 | 20 | ||
| 25884959288 | 21 | ||
| 23046629148 | 22 | ||
| 20208299008 | 23 | ||
| 17369968868 | 24 | ||
| 17369968868 | 25 | ||
| 17369968868 | 26 | ||
| 17369968868 | 27 | ||
| 15439972327 | 28 | ||
| 13509975786 | 29 | ||
| 11579979246 | 30 | ||
| 9649982705 | 31 | ||
| 7719986164 | 32 | ||
| 5789989623 | 33 | ||
| 3859993082 | 34 | ||
| 1929996541 | 35 | ||
| IRR | #NUM! |
| |
|