Calculation question

Bryan · Mar 16, 2005

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 · Mar 16, 2005

Hi Bryan

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

cheers
JulieD

Bryan · Mar 16, 2005

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 · Mar 16, 2005

Hi Bryan

-- some people!

--

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

Cheers
JulieD

Bryan · Mar 16, 2005

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

JulieD · Mar 16, 2005

you're welcome and thanks for the feedback

Bryan said:
Thanks Julie!
That was it!! I really Appreciate your help!!