Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding 2 digits of a number together
Hello all, I am trying to do something simple, although my explanation may seem complicated.
2 input cells and 1 output cell. input cells will hold 2 unique single digit numbers. output cell to add both output cells together. I then want the output cell to add the 2 digits together and give me the final one digit number. example 1: Step one: 2 + 9 = 11 Step two: 1 + 1 = 2 (final output) example 2: Step one: 9 + 6 = 15 Step two: 1 + 5 = 6 (final output) any gurus able to enlighten me on this please? TIA! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding 2 digits of a number together
Le 16/10/2020 Ã* 17:13, Gabriel C ZX a écritÂ*:
Hello all, I am trying to do something simple, although my explanation may seem complicated. 2 input cells and 1 output cell. input cells will hold 2 unique single digit numbers. output cell to add both output cells together. I then want the output cell to add the 2 digits together and give me the final one digit number. example 1: Step one: 2 + 9 = 11 Step two: 1 + 1 = 2 (final output) example 2: Step one: 9 + 6 = 15 Step two: 1 + 5 = 6 (final output) any gurus able to enlighten me on this please? TIA! Hello Gabriel, Not tryed :=mod(sum(...),9) Regards FxM |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding 2 digits of a number together
On Friday, October 16, 2020 at 8:13:19 AM UTC-7, Gabriel C ZX wrote:
Hello all, I am trying to do something simple, although my explanation may seem complicated. 2 input cells and 1 output cell. input cells will hold 2 unique single digit numbers. output cell to add both output cells together. I then want the output cell to add the 2 digits together and give me the final one digit number. This seems to work: =MOD(A1+B1, 10) + (A1+B1 9) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA write macro change column with 3 number digits to 4 digits the | Excel Discussion (Misc queries) | |||
number 12 digits to 15 digits | Excel Discussion (Misc queries) | |||
How to customize number to 10 digits including 2 digits after deci | Excel Worksheet Functions | |||
Adding digits | Excel Worksheet Functions | |||
adding digits of a number | Excel Worksheet Functions |