For all you excel monkeys out there I could use some help.
I'm currently trying to create a function that checks if a given interest rate is within both an annual (change from last year) and lifetime cap.
Annual cap is 1% lifetime cap is 5% (beginning interest rate is 6.75%).
I tried an IF statemetn and that turned into a black hole. Also messed around with a MAX and MIN function to no avail...