View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MyVeryOwnSelf[_3_] MyVeryOwnSelf[_3_] is offline
external usenet poster
 
Posts: 56
Default 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)