=INT(A1/1000)*10

and be sure to format the cells in column B as number rather than currency.


Have a Good Day!
--
Gary's Student


"Andyp" wrote:

I need to attribute 10 points for every £1000 revenue achieved. So for
example £1800 would be 10 points, 5760 would be 50 points etc. If I have
column A with the revenue figure, what formula would I use to work out the
number of points, which would be placed into column B?