A
annysjunkmail
HI Group,
I have been asked to work out a risk assessment based on some of the
following grid/variables (there are 3 more to build...)
Loan Rating Weight Item Rating Weight
10000 1 4 Capital 1 3
25000 2 4 Revenue 2 3
50000 3 4 Unknown 3 3
75000 4 4
100000 5 4
1000000 6 4
For example, If an applicant has the following criteria...
Loan Item
15000 Revenue
....then the risk rating is (2 x 4) + (2 x 3) = 14
I have done a bit of searching and think I need Vlookup but I am not
sure to implement the logic.
Can someone help.
Thanks
Chris
I have been asked to work out a risk assessment based on some of the
following grid/variables (there are 3 more to build...)
Loan Rating Weight Item Rating Weight
10000 1 4 Capital 1 3
25000 2 4 Revenue 2 3
50000 3 4 Unknown 3 3
75000 4 4
100000 5 4
1000000 6 4
For example, If an applicant has the following criteria...
Loan Item
15000 Revenue
....then the risk rating is (2 x 4) + (2 x 3) = 14
I have done a bit of searching and think I need Vlookup but I am not
sure to implement the logic.
Can someone help.
Thanks
Chris