Hey Everyone just need a little bit of help, not so good with trying to turn algebra into excel formulas :/
basically I'm matching a Company Clause to point system, so the amount of breached clauses equals a total of point
for example Company A has breached clause 1,2 and 3
Clause 1 = 10 ( High breach level)
Clause 2 = 5 (Medium breach level)
Clause 3 = 5 (Medium breach level)
(note any point breach total over 10 = high risk)
so therefore Company A - breached Clause 1,2,3 = 20 points = high Risk break
Any help is really appreciated
document attached with dummy solution
Bookmarks