Forum Discussion
Formulae for add mobile numbers?
Formulae for add mobile numbers. Ex : 987543210 -> 9+8+7+6+5+4+3+2+1+0=45
Gsr25051981 Result should be 39 as digit 6 is missing to your given mobile number. Try-
=SUM(--MID(A1,SEQUENCE(LEN(A1)),1))
Formulae for add mobile numbers. Ex : 987543210 -> 9+8+7+6+5+4+3+2+1+0=45
Gsr25051981 Result should be 39 as digit 6 is missing to your given mobile number. Try-
=SUM(--MID(A1,SEQUENCE(LEN(A1)),1))
