Nested IF to calculate credit rating

how to calculate credit rating

Tags: None

Bee82 said: May 22nd, 2014 10:40 PM

Nested IF to calculate credit rating

Hi,

I saw one of your posts and tried to apply that for my IF statement to determine credit rating but i am sure there is something i am not doing right. Can you please help.

I need to to achieve the following:

If score is less then 0 then customer to get credit rating of NO RATING

If score is more then 1 or equals to 10 then customer to get credit rating of D-

If score is more then 11 or equals to 20 then customer

to get credit rating of D

If score is more then 21 or equals to 30 then customer to get credit rating of C-

If score is more then 31 or equals to 40 then customer to get credit rating of C

If score is more then 41 or equals to 50 then customer to get credit rating of B-

If score is more then 51 or equals to 60 then customer to get credit rating of B

If score is more then 61 or equals to 70 then customer to get credit rating of A-

=IF(B2>91=100,”AAA”,IF(B2>81= 90,”AA”,IF(B2>71=80,”A”,IF(B2> 61=70,”A-”,IF(B2>51=60,”B”,IF( B2>41=50,”B-”,IF(B2>31=40,”C”, IF(B2>21=30,”C-”,IF(B2>11=20,” D”,IF(B2>1=10,”D-”,IF(B2 NOT RATED")))))))))))

Please if someone can help me with this

Source: www.mrexcel.com

Category: Credit

Similar articles: