Need an Excel/Google Sheet Formula for finding Delta ValuePrev TopicNext Topic

• ScreamingMidget

  

  Florida
  United States
  Member #126,768
  April 16, 2012
  1,872 Posts
  Offline
  Dec 20, 2017, 2:02 pm

  ▲▼

  Hey guys, I'm just looking for a formula or something to help make things easier for me.

   

  In the screen shot below, you can see I type out the draws, then there's the Pair ShortSUM's which are already formulated.

   

  I was wondering if someone knew a formula that can calculate the delta value for the draw?

   

                 _____8_______

                |                      |

  0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0

  So as you can see with the number line, 5 to 3 is 8 spaces.

   

  I was going to do this for all 3 deltas(5>3, 3>6, 6>2), and then hide those columns and use another formula to 

  put all 3 in the "Delta" Column.

   

  Thanks!

   

  
• Raven62

  

  25

  New Jersey
  United States
  Member #17,842
  June 28, 2005
  180,983 Posts
  Offline
  Dec 20, 2017, 3:10 pm

  ▲▼

  =IF(C3<B3,C3+10-B3,C3-B3)

  A mind once stretched by a new idea never returns to its original dimensions!
  
  Catch-22: A dilemma or difficult circumstance from which there is no escape because of mutually conflicting or dependent conditions.
  
  Corruptissima re publica plurimae leges: When the republic is at its most corrupt the laws are most numerous.
  
  The best way to learn is to never stop being an Experiential Student!
• ScreamingMidget

  

  Florida
  United States
  Member #126,768
  April 16, 2012
  1,872 Posts
  Offline
  Dec 20, 2017, 3:17 pm

  ▲▼
  In response to Raven62

  Quote: Originally posted by Raven62 on Dec 20, 2017

  =IF(C3<B3,C3+10-B3,C3-B3)

  Oh man! Thanks so much Raven! This is going to save me so much time!