Calculation question
 

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?

Hi Bryan

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

cheers
JulieD

"Bryan" wrote in message
...
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?

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" wrote:

Hi Bryan

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

cheers
JulieD

"Bryan" wrote in message
...
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?

Hi Bryan

-- some people! :) --

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

Cheers
JulieD

"Bryan" wrote in message
...
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" wrote:

Hi Bryan

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

cheers
JulieD

"Bryan" wrote in message
...
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?

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

"JulieD" wrote:

Hi Bryan

-- some people! :) --

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

Cheers
JulieD

"Bryan" wrote in message
...
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" wrote:

Hi Bryan

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

cheers
JulieD

"Bryan" wrote in message
...
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?

you're welcome and thanks for the feedback

"Bryan" wrote in message
...
Thanks Julie!
That was it!! I really Appreciate your help!!

"JulieD" wrote:

Hi Bryan

-- some people! :) --

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

Cheers
JulieD

"Bryan" wrote in message
...
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" wrote:

Hi Bryan

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

cheers
JulieD

"Bryan" wrote in message
...
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?