View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default ? 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
###-###-###.