Hi, !


i would like to find if in 5 digits 1 digit is the sum of 2 digits, (or) the Sum of 3 Digits

it's might a lil complex, i've tried to doit but the problem is that the string is inside of single cell
and it's contain a dash.. ( i'm not excel guru yet)

Let say in G:12 I got a combination of 5 numbers (separated with dash)

then i wan to find if in combination a number have a sum of 2 digit or 3 digits, and if Found
then i would like to identify as :
-.If No Digit Sum any other digit, then "0D"
-.If 1 Digit is the Sum of 2 other Digit, then "2D"
-.If 1 Digit is the Sum of 3 other Digit, then "3D"

then the result ("OD","2D,"3D") will Add dd in Cell/Column AB:12 down


example:
______________________RESULT
____________COL G______COL AB__
R:12___01-02-05-33-35____ "0D", <--because, no 2 or 3 digit make a Sum of 1 Digit
R:13___01-02-06-15-33____ "0D", <--because, no 2 or 3 digit make a Sum of 1 Digit
R:14___02-05-08-17-20____ "0D", <--because, no 2 or 3 digit make a Sum of 1 Digit
R:15___05-06-14-15-23____ "0D", <--because, no 2 or 3 digit make a Sum of 1 Digit
R:16___01-02-05-33-35____ "2D", <--because, Digit Sum 02+33 is equal to Digit 35
R:17___01-02-06-08-32____ "2D", <--because, Digit Sum 02+06 is equal to Digit 08
R:18___02-05-07-08-20____ "2D", <--because, Digit Sum 02+05 is equal to Digit 07
R:19___05-06-14-19-29____ "2D", <--because, Digit Sum 05+14 is equal to Digit 19
R:20___01-02-05-08-19____ "3D", <--because, Digit Sum 01+02+05 is equal to Digit 08
R:21___01-02-05-14-20____ "3D", <--because, Digit Sum 01+05+14 is equal to Digit 20
R:22___01-02-06-19-26____ "3D", <--because, Digit Sum 01+06+19 is equal to Digit 26
R:23___02-05-08-28-35____ "3D", <--because, Digit Sum 02+05+28 is equal to Digit 35




Thank you for your help !!



Best Regards

David