Change remainder to whole number?

[dkeith1977]

I want to basically be able to use the remainder as a whole number.
So I may have a problem that is 277/10 = 27.7 So my remainder is .7 , I want to be left with only 7
I need to be able to take any remainder and subtract it from 10
So if my answer has a remainder of .7 I need to be able to do 10-7=3
If my answer has a remainder of .4 I need to be able to do 10-4=6 and so on.


I can not use RIGHT(A1,1) because it is a remainder so right goes to the end of the remainder which could be .699999999995 and it returns 5.


So I thought about trying to strip it somehow but have not been able to come up with anything. Any help would be greatly appreciated!


Thanks in advance.

 

[joeu2004]

=mod(round(a1*10,0),10)

 

[dkeith1977]

That worked perfectly. Thank you very much.