Formula to Make Calculation Based on Items Selected

Hello Excel Forum,

I've created a spreadsheet that I would like to use to determine the recoup time of buying down an interest rate based on the data input into a table. I've created drop downs for the interest rate selection based off of the table. I would like to be able to make the recoup time calculation be dependent on what is selected in that drop down menu. For instance, if 8.25% & 7.375% are selected then it would utilize the data for the price in dollars and the payment to make the calculation for recoup time. I've manually made that calculation for the moment in the spreadsheet to show what I'm after. I'm not even sure if what I'm asking to be able to do is a possibility, but it seems like it could be.

Thank you for any and all assistance!

Welcome to the forum.

MAybe this:

Formula:

Please Login or Register  to view this content.

Good luck!

Thank you so much!!! I had to adjust slightly for my version, but that did the trick for me! I've been struggling for way too long over figuring this out. Thank you again!

Could also be:

Formula:

Please Login or Register  to view this content.

You’re welcome. Glad to help.
Thank you for the feedback and for the reputation added.
Have a blessed day.