[Solved] Adding two digits together of a two-digit number

[MrProgrammer]

Is there a formula in OOC that I can use either digit separately of a two-digit number for a calculation? Or, how do I return digit x, or y, or z of an xyz number? Return 3 of 235?
Thanks for any help you might offer.

[Zizi64]

Or, how do I return digit x, or y, or z of an xyz number? Return 3 of 235?

Just a tip:

Convert it to text, then use the Function LEFT(), RIGHT() functions. If you need a numeric value, then convert it again by the function VALUE()

Code: Select all   Expand viewCollapse view

=VALUE(RIGHT(LEFT(TEXT(A1;"000");2);1))

[Zizi64]

Or you can use the functions INT() and MOD():

Code: Select all   Expand viewCollapse view

= INT(235/100)             -> 2
= MOD(INT(235/10);10)      -> 3
= MOD(235;10)              -> 5


[MrProgrammer]

Subject: Adding two digits together of a two-digit number:
Is there a formula in OOC that I can use either digit separately of a two-digit number for a calculation? Or, how do I return digit x, or y, or z of an xyz number?

Adding to Zizi64's second solution with value 235 in cell A2:
=MOD(QUOTIENT($A$2;10^0);10) is 5 (digit position 0)
=MOD(QUOTIENT($A$2;10^1);10) is 3 (digit position 1)
=MOD(QUOTIENT($A$2;10^2);10) is 2 (digit position 2)
=MOD(QUOTIENT($A$2;10^3);10) is 0 (digit position 3)
=MOD(QUOTIENT($A$2;10^4);10) is 0 (digit position 4)
Thus, you can use the same expression structure for each digit position. The exponent (0,1,2,3,4) could also be a cell reference.

More generally, since you have asked about adding digits together:
=SUM(MOD(QUOTIENT($A$2;10^{0;1});10)) is 8 (5+3) (digit positions 0 and 1)
=SUM(MOD(QUOTIENT($A$2;10^{1;2});10)) is 5 (3+2) (digit positions 1 and 2)
=SUM(MOD(QUOTIENT($A$2;10^{0;2});10)) is 7 (5+2) (digit positions 0 and 2)
=SUM(MOD(QUOTIENT($A$2;10^{0;1;2});10)) is 10 (5+3+2) (digit positions 0, 1, and 2)
Each SUM() expression must be entered as an Array formula so type it and and press ⇪⌘Enter (Shift+Command+Enter) on a Mac or Ctrl+Shift+Enter on other platforms; if you press Enter by mistake, use Edit → Delete Contents → Formulas, then try again.

If you need further assistance attach a document demonstrating the situation (remove confidential information then use Post Reply, not Quick Reply, and don't attach a picture instead of the document itself).

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know