Help!! with a formula

A

Andyp

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

Gary's Student

=INT(A1/1000)*10

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


Have a Good Day!
 
B

Bob Phillips

=int(A1/100)

--

HTH

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

Andyp

Thank you - that is great

Gary's Student said:
=INT(A1/1000)*10

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


Have a Good Day!
Click to expand...
 
Top