I would like to return the internal rate of return (expressed as a %age p.a.) of a series of monthly payments/receipts, where the monthly figure may be zero (neither payment nor receipt) in some months. I can do this easily on my very old spreadsheet, but have not yet succeeded with Excel using the IRR function. Can you help, please?