Simple problem I'm sure

J

John

I need excel to return a value of 1 for every 10000 members. ie 10000 = 1 but
20000 = 2 and 100000 = 10 etc.

Can anyone help with this Formula. It's probably very simple.
 
B

Barb Reinhardt

You could try

=INT(A1/10000)

If the A1=39999, you'll get three.

If you want it to round up, try

=ROUND(A1/10000,0)
 

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

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Finding the right style field in VBA 0
Finding the proper style field and the numbered paragraph value within the style 0
Pulling out values 2
Get percentage of whole 2
Merging from an Excel file with graphics 1
Address fields in columns... 6
Formula Help 2

Top