Welcome Guest
Log In | Register )
You last visited December 10, 2016, 5:13 pm
All times shown are
Eastern Time (GMT-5:00)

Lotto Math with Excel Help Needed

Topic closed. 3 replies. Last post 6 years ago by starks.

Page 1 of 1
PrintE-mailLink
Rakster's avatar - praying hands.jpg
Saskatchewan
Canada
Member #19992
August 9, 2005
2867 Posts
Offline
Posted: May 22, 2010, 4:40 pm - IP Logged

What formula does one use in Excel to get 0 - 1 = 9 in lotto math?

just plugging it into excel it gives me -1

I need it to produce 9

We are all Lucky... just some of us don't realize it!

    JonnyBgood07's avatar - Patriots logo1.jpg
    Connecticut
    United States
    Member #61623
    May 29, 2008
    20581 Posts
    Offline
    Posted: May 22, 2010, 5:02 pm - IP Logged

    calabs just helped me with thath the other day...

    =MOD(A1-1,10)

    "No matter how bad things may get, I'd like to thank my middle finger

    for always sticking up for me.."

     


      Rakster's avatar - praying hands.jpg
      Saskatchewan
      Canada
      Member #19992
      August 9, 2005
      2867 Posts
      Offline
      Posted: May 22, 2010, 5:03 pm - IP Logged

      Thanks Jonny!

      We are all Lucky... just some of us don't realize it!

        Avatar
        New Member
        Forestburgh, New York
        United States
        Member #92960
        June 18, 2010
        1 Posts
        Offline
        Posted: June 21, 2010, 11:24 am - IP Logged

        whats the formula for the whole thing?