Good morning all,
I'm trying to build a lending price model for my boss. Basically one that can determine the interest rate based on some inputs.
Here are the criteria -
1. Credit score - which I have defined as 720+, 719-690, etc
2. The year the vehicle was made - 2015-2017, 2012-2014, etc
3. The term of the loan - 48, 64-75, etc.
Depending on what each criteria has been selected will determine an interest rate.
Is this something I can do with formulas or am I going to have to write a macro instead? I'm not shy to macros as I've written a few over 1,000 lines of code. It may even be easier to go the macro route. My goal is to make it as simplistic I can for my boss. Thanks for your opinions!
I'm trying to build a lending price model for my boss. Basically one that can determine the interest rate based on some inputs.
Here are the criteria -
1. Credit score - which I have defined as 720+, 719-690, etc
2. The year the vehicle was made - 2015-2017, 2012-2014, etc
3. The term of the loan - 48, 64-75, etc.
Depending on what each criteria has been selected will determine an interest rate.
Is this something I can do with formulas or am I going to have to write a macro instead? I'm not shy to macros as I've written a few over 1,000 lines of code. It may even be easier to go the macro route. My goal is to make it as simplistic I can for my boss. Thanks for your opinions!