Hi,
Perhaps a tiered minimum situation can apply.
By using this formula the points can be awarded. If you need something more elaborate you may need to attach a workbook stating your criteria.
The formula for finding the points:
Formula:
=VLOOKUP(G3,$C$4:$D$10,2,TRUE)
I hope this helps
Bookmarks