mardi 29 août 2017

I need help writing an if then statement using 2 criterion of ltv and credit score

Please help! I've been ripping my hair out trying to figure this out on Excel.

I'm trying to write a code that outputs a percentage value based off of LTV and Credit score range. If the LTV is equal to or above 75, and has a credit score >725 then -.25. If the LTV is equal to or above 75 with a credit score between 724 and 675 then +1.25. If the LTV is equal to or above 75 with a credit score 625-674 then +1.75

I also need to write a statement if the LTV is below 75 for the same credit socres above. 725, 724-675, 674-625.

I keep getting an error that Im using too many arguments.

Aucun commentaire:

Enregistrer un commentaire