bakbuk -

With the years in A2:A11 and the cash flows in B2:B11, in another cell
=IRR(B2:B11) returns 34%.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel



"bakbuk" wrote in message
...
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!