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: copy to clipboard 


=VLOOKUP(G3,$C$4:$D$10,2,TRUE)


I hope this helps