I am trying to calculate IRR for a real estate investment. I have forecast
over 25 years. The problem is, I know the cash flows for each year if the
property is not sold. However, when sold I need to add the proceeds of sale
into the cash flows from that year.

Question: Can I input cashflows into the IRR function without having them
in a single column/row?