Forum Discussion
What is wrong with my if and formula
I am trying to have it calculate a rate based off of the credit score which is in C and the term which is in K =IF((AND((C2<=579),(K2<=36))),(E2-0.3),(IF((AND((C2<=579),(37<=K2,K2<=60))),E2,(IF((...
It would be better (Less confusing + easier to maintain when there are changes), if you created two dim tables, one for credit score and one for term, which would greatly simplify your decision IF() formula as well and create a formula like i.e.:
IF(VLOOKUP( CreditScoreValue, CreditScoreTable, [ReturnValue],0), [DoAnotherEvaluation or DoThisCalculation], [DoAnotherEvaluation or DoThisCalculation])