? Link attached - How to validate SIN (Social Insurance Number)
I appreciate everyone's efforts. Basically, I would like to keep the
output simple. True or False as an output is fine. Unfortunately,
with all the examples posted here, I was not able to get any of the
formulas to take ie. excel to accept them.
Don't know what I am doing wrong. But, one of the error messages in the
formula
=SUMPRODUCT(INT((A1:I1)*{1,2,1,2,1,2,1,2,1}/10)+MOD((A1:I1)*{1,2,1,2,1,2,1,*2,1},10))
shows "(MOD, number, divisor) -2" error.
I have tried to enter each digit in it's own field and entered the SIN
in ONE field. In this field, I used a custom format of 000-000-000 or
###-###-###.
|