If you won't have very small increments

=FLOOR(A21-1/10^10,10)

--
__________________________________
HTH

Bob

"wilchong via OfficeKB.com" <u43231@uwe wrote in message
news:88277aa4e627b@uwe...
I have a problem for an excel formula. I want to convert 1 to 0, 2 to
0,......
.., 10 to 0. And convert 11 to 10, 12 to 10,............, 20 to 10.

I know the formula of FLOOR can have this function, however, it will
convert
10 to 10, 20 to 20 which is not I want. What I want is to convert 10 to 0,
20
to 10, 30 to 20, 40 to 30. Therefore, how can I achieve this result by
using
Excel Formular?

Many thanks,
Wilchong

--
Message posted via http://www.officekb.com