Hi wilchong
Try
=FLOOR(A21,10)-(A21=FLOOR(A21,10))*10

Regards,
Pedro J.



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