ExcelBanter - Simple problem I'm sure

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Simple problem I'm sure (https://www.excelbanter.com/new-users-excel/71700-simple-problem-im-sure.html)

John

Simple problem I'm sure

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.

Barb Reinhardt

Simple problem I'm sure

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)

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

All times are GMT +1. The time now is 09:34 AM.