Calculation question

[Guest]

I have a calculation that I do not even know where to begin with. It is a
check digit calculation. I can easily come up with the sum, but then the fun
begins. I need to divide the sum by 10. Seems easy enough, except that I
need to end up with a remainder, not a fraction or decimal. So if i end up
with 79, I need to end up with the 9 or eventually after subtracting the
remainder from 10, the 1. In this case the 1 is the check digit. Any ideas?

 

[JulieD]

Hi Bryan

with your number in A1
=10-Mod(A1,10)

cheers
JulieD

 

[Guest]

Awesome! Thanks! One more question I forgot in my first post. If the check
digit is a 10, then I need it to be 0.

 

[JulieD]

Hi Bryan

-- some people! --

=IF(A1=10,0,10-MOD(A1,10))

Cheers
JulieD

 

[Guest]

Thanks Julie!
That was it!! I really Appreciate your help!!

 

[JulieD]

you're welcome and thanks for the feedback

Thanks Julie!
That was it!! I really Appreciate your help!!