The MIRR formula works well when comparing investments that have equal lifetimes. However, if the investments have different lifetimes or if there are intermediate cash flows during the investment period, MIRR can be unreliable. Also, MIRR should not be used as the only criteria for evaluating an investment as there are other factors like risks involved.