IRR not working Please urgent help

IRR(values, [guess])

The IRR function syntax has the following arguments:

Values Required. An array or a reference to cells that contain numbers for which you want to calculate the internal rate of return.

Values must contain at least one positive value and one negative value to calculate the internal rate of return.

IRR uses the order of values to interpret the order of cash flows. Be sure to enter your payment and income values in the sequence you want.

The best way: read here IRR function

repsolv.gif