"joeu2004" wrote in message
...
On Aug 5, 11:36 am, Ron Rosenfeld wrote:
Left unsaid is what should happen to a non-integer such as 10.9
Since 10.9 is greater than 10, I would have thought it should be
rounded down to 10.

Your formula would round it down to 0.

And my point was: left unsaid, there is no reason to think I was
wrong.

I interpreted the OP's intention to be: everything below 11 should
round down to 0, everything below 21 should round down to 10, etc.
Since it was left unsaid, I see no reason to think your interpretation
is any more or less reasonable than mine.



How about a vote? :) I would definitely go for Ron's interpretation,
to me it would be more logical that everything greater than 10 less than or
equal to 20
would be rounded down to 10. Of course the OP also said:

"What I want is to convert 10 to 0, 20
to 10, 30 to 20, 40 to 30"

I think it is more likely that means up to and include 10 to 0 but greater
than 10
will be 10. Of course Bob's formula would do that as well besides working
for less than 1 as long it is greater than 0.


--


Regards,


Peo Sjoblom