Help!! with a formula

G

Guest

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

Guest

=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)
 
G

Guest

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

named ranges 4
IF IS NULL PROBLEM 3
Help on Formula- 1
3 tier incentive matrix w/ infinite possibilities 7
Help for a formula using two conditions 7
help with sales formula 2
Adding formula 1
Can I use SUMIF and AND together 4

Top