Loyalty Scorecard

Dear All,
I have a small supermarket, and I want to make loyalty program for my clients so I will give point(s) for each pound paid, monthly I will calculate each client's total spending and accordingly will give him points.
Example:
TTL Spending Points
0 - 500 0
501 -1,000 100
1,001 -2,000 120
2,001 -3,000 150
Any Ideas.
Tks

Make a little table somewhere showing the start of each spending range and the number of points for each range, like this:

0 ... 0
501 ... 100
1001 ... 120
2001 ... 150

Suppose you put this in X1 to Y4. Then if your monthly spend is in column M, starting with M2, then you can have this formula in N2:

=VLOOKUP(M2,$X$1:$Y$4,2)

to return the points. Copy this down as required.

Hope this helps.

Pete

Thanks for quick answer, but I didn't understand how I apply it, I attached a sheet can you please show me how to use the formula
Thanks

Put this formula in D4 of Sheet1:

=VLOOKUP(C4,Sheet2!$B$2:$D$7,3)

then copy down.

Hope this helps.

Pete

Thanks
it's working
Many Many Thanks