I want to include two conditions within an IF formula

Hello All,
I have this sheet that I need to use two formulas with. XIRR to calculate the IRR for a project and MIRR to calculate whenever the XIRR formula returns an error or a zero value.
I tried the following:
=IF(IFERROR(XIRR(D87:N87,D88:N88),0)=0,MIRR(D87:N87,0.1,0.02),XIRR(D87:N87,D88:N88))
D87:D87 represent the net cash flows
D88:N88 represent the corresponding dates
I know where the error in my formula is coming from. the logical test returns "True" rather than 0.
What I want from the formula is the following, Calculate the IRR using XIRR formula, if that calculation returns and ERROR or a ZERO value, then skip and calculate using MIRR formula instead. I am doing this because I want to use XIRR formula not considering we're reinvesting the cash flows but many times when I have a series of positive net cash flows and then in the 5th year for example it turns negative, XIRR formula returns an error of a zero value, which most of the time does not happen with MIRR formula.
I tried different formulas and this is the one I lost hope at. If you have better suggestions, it would be greatly appreciated.
I would really appreciate any help I can get. Thanks for anyone who can help me in advance.
Example.pngExample.xlsx
Regards
Abdel

Thank you!
I tired this but it returned a #NUM!
I don't know why!

1. I took the screen shot before changing numbers to dates after I copied from my original file. In the attached excel, the dates are in the correct format.
2. In fact having a negative cash flow after a series of positive cash flows is probably what causes this error. If you calculate using XIRR with a series of positive cash flows only, you wouldn't get any errors. In real world this is not realistic, you can have some projects with initial investment and then positive returns or negative net return in a following year.

Hello everyone. Just want to tell you that the formula below worked when I replaced the value in the "Or" function with external cells rather than including then within the formula. I think it was due to the fact that the formula return True instead of returning a value which is why I had to take another path and take one of the formulas out and evaluate separately. Thanks everyone.
Old formula =IF(OR(ISERROR(XIRR(D87:N87,D88:N88)),XIRR(D87:N87,D88:N88)=0),MIRR(D87:N87,0.1,0.02),XIRR(D87:N87,D88:N88))
New formula =IFERROR(IF(OR(Q73="NO IRR",(ROUND(Q73,1)=0)),"IRR Not Computed",XIRR(D60:N60,D69:N69)),"IRR Not Computed")
Where Q73==IFERROR(XIRR(D60:N60,D69:N69),"NO IRR")
I know I put a lot of Iferror in there but I was being cautious after all the struggle I had with this. Thanks everyone and hope no one suffers from finding this formula now.