How to rate a supplier and then grade him

Closed
Report
-
Posts
1021
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
-
Hello,

I want to rate my suppliers on thier delivery ( from purchase order date to receipt of material ) and then grade them.

Delivery within schedule date = 50 marks
3 - 6 days late beyond schedule = 35 marks
above 6 days = 15 marks

50 marks will be A grade
50-35 will be B grade
35 - 0 will be C grade

Kindly help me on this

Thank u

Prashanth

1 reply

Posts
1021
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
182
you could use conditional formatting
which version of excel are you using?
0