can someone help with this math equation issue I am having?Prev TopicNext Topic

• dreamachievers

  

  savannah, georgia
  United States
  Member #185,685
  November 13, 2017
  13 Posts
  Online
  Feb 6, 2021, 3:57 pm

  ▲▼

  I want to add and subtract using lotto math.  my results come out with an minus or 2 digit answer.  How do you program it to be 0 thru 9 as an answer? 

  thanks to anyone willing to help me.

  example: 2+9=1

  2-9=3
• Todd

  

  50

  Chief Bottle Washer

  New Jersey
  United States
  Member #1
  May 31, 2000
  27,936 Posts
  Online
  Feb 6, 2021, 4:04 pm

  ▲▼

  <Moved to Mathematics forum>

  Please post in the appropriate forum ... thank you.
• dreamachievers

  

  savannah, georgia
  United States
  Member #185,685
  November 13, 2017
  13 Posts
  Online
  Feb 6, 2021, 4:39 pm

  ▲▼

  Thank you
• db101

  

  United States
  Member #202,920
  December 14, 2019
  900 Posts
  Offline
  Feb 6, 2021, 6:52 pm

  ▲▼

  It's modular arithmetic, use a mod 10 function. In Excel I think it's =MOD(2-9,10) and in other programming languages you have to look up the syntax for mod.
• pavizlo$

  

  OKC, OK
  United States
  Member #120,569
  December 22, 2011
  1,431 Posts
  Offline
  Feb 6, 2021, 9:48 pm

  ▲▼

  For example you have the number 2 in cell a1 and 9 in cell b1. If you want the answer in the cell c1, you could type this formula in the cell c1:

  =mod(($a$1+$b$1),10)  for addition

  or

  =mod(($a$1-$b$1),10) for subtraction

   

  There is more than one way do this.

  Good Luck everyone
• AllenB

  

  California
  United States
  Member #167,122
  June 27, 2015
  1,635 Posts
  Offline
  Mar 3, 2021, 3:06 pm

  ▲▼

  You can also specify the right digit only by surrounding the formula with "Right(Formula,1)*1

  You will get a single digit that is always positive and I believe is the equivalent of what we all call "Lottery Math"
• cottoneyedjoe

  

  United States
  Member #197,030
  March 28, 2019
  1,639 Posts
  Offline
  Mar 3, 2021, 8:58 pm

  ▲▼
  In response to AllenB

  Quote: Originally posted by AllenB on Mar 3, 2021

  You can also specify the right digit only by surrounding the formula with "Right(Formula,1)*1

  You will get a single digit that is always positive and I believe is the equivalent of what we all call "Lottery Math"

  Unfortunately that method loses coherence for negative inputs. OP wants a function that returns "3" when the input is "2-9". When you run the =RIGHT() formula it returns "7" rather than "3." =MOD(~~~,10) returns the correct result.
• AllenB

  

  California
  United States
  Member #167,122
  June 27, 2015
  1,635 Posts
  Offline
  Mar 4, 2021, 10:04 am

  ▲▼
  In response to cottoneyedjoe

  Quote: Originally posted by cottoneyedjoe on Mar 3, 2021

  Unfortunately that method loses coherence for negative inputs. OP wants a function that returns "3" when the input is "2-9". When you run the =RIGHT() formula it returns "7" rather than "3." =MOD(~~~,10) returns the correct result.

  Thanks for the correction cottoneyedjoe.

  Good thing I stopped using minus formulas at the Cricket Ranch.