Help!! with a formula
 

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?

=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?

=int(A1/100)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Andyp" wrote in message
...
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?

Thank you - that is great

"Gary's Student" wrote:

=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?