How do I calculate a several tier IRR waterfall?

Terms change in my transaction after a specific IRR (internal rate of return)
is acheived. I can test for what year that IRR is triggered. How do I
calculated what is the amount in that year to help the step and use the next
tier of the waterfall?

Is this close to what you need?
=IF(IRR(F9:F14)<0.095,"1stTier",IF(AND(IRR(F9:F14)>=0.095,IRR(F9:F14)<0.105),"2ndTier","3rdTier"))

Originally Posted by Dan

Terms change in my transaction after a specific IRR (internal rate of return)
is acheived. I can test for what year that IRR is triggered. How do I
calculated what is the amount in that year to help the step and use the next
tier of the waterfall?