Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IRR showed #NUM!
I am trying to use IRR function for my string of cash flows for 10 years:
Year | Cash Flows 2009 | -272,895,028,812 2010 | -207,524,139,910 2011 | -185,716,940,803 2012 | -9,306,121,279 2013 | 326,372,394,532 2014 | 245,782,146,138 2015 | 501,268,808,310 2016 | 497,663,783,563 2017 | 493,577,645,807 2018 | 488,974,344,794 The formula I am using is simply: =IRR("Range of Data") I am getting the #NUM! error...any assistance please? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I change the name showed when worksh is "locked for editin | Excel Discussion (Misc queries) |