Looking for some help creating an auto calculator. I have a table of data, the top row is for a term of say 36 months, 48 months, then I have a set dollar amount between 0-9999 and 10000 - 15000. I want to pull the rate based on the dollar amount and the term. Any ideas?![]()
36 48
9999 0.022 0.033
10000 0.044 0.0555
Bookmarks