The syntax for the IRR function is: =IRR(values) The "values" are the range of cells containing the cash flows. Make sure to select all cash flows including the initial investment. Example ...