Forum Discussion
Formula
I have two no in one cell and i want addition of that two no in another cell which formula I have to use please guide
Here is the simplest formula for the checksu.
For multi-digit numbers you have to expand the formula accordingly.
Example 1: "=MID(A1,1,1)+MID(A1,2,1)+MID(A1,3,1)", use without goosefoot.
Example 2: "=SUMPRODUCT(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)*1) ", use without goosefoot.
Example 3: "{=SUM(1*MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))}" , use without goosefoot.
*3 Array formulas must always be confirmed with the key combination "CTRL + SHIFT + ENTER"
The file with the examples is included.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)