Welcome Guest
Log In | Register )
You last visited April 30, 2017, 6:43 am
All times shown are
Eastern Time (GMT-5:00)

P3 REST( ax+b, m)

Topic closed. 23 replies. Last post 10 months ago by Sunglasses.

Page 2 of 2
52
PrintE-mailLink
Sunglasses's avatar - nicebear
Thread Starter
Zaperlopopotam
Belgium
Member #173932
March 26, 2016
1309 Posts
Online
Posted: July 2, 2016, 3:56 pm - IP Logged

I get an error message when I type this in.

That is normal on an English American machine.

    Sunglasses's avatar - nicebear
    Thread Starter
    Zaperlopopotam
    Belgium
    Member #173932
    March 26, 2016
    1309 Posts
    Online
    Posted: July 2, 2016, 4:01 pm - IP Logged

    The randbetween function works with a modification.

     

    720  input

    999

    =RANDBETWEEN( E2,E3)

    720  input

    999

    929  result

     

    Yet another attempt with 720 as the input and using randbetween and then -111.

     

    720

    999

    848  result then -111

    737

    626

    515

    404

    293

    randbetween has no parameter for the seed

    that would be a quickpick not a system

      lakerben's avatar - Trek Galaxy2.gif
      New Mexico
      United States
      Member #86099
      January 29, 2010
      11341 Posts
      Offline
      Posted: July 2, 2016, 5:09 pm - IP Logged

      randbetween has no parameter for the seed

      that would be a quickpick not a system

      Is there another function in excel that works for the seed?

       

      Idea

        Sunglasses's avatar - nicebear
        Thread Starter
        Zaperlopopotam
        Belgium
        Member #173932
        March 26, 2016
        1309 Posts
        Online
        Posted: July 2, 2016, 6:29 pm - IP Logged

        Is there another function in excel that works for the seed?

         

        Idea

        LINKs https://www.lotterypost.com/thread/304462/4678491 https://www.lotterypost.com/thread/304462/4678845

          Sunglasses's avatar - nicebear
          Thread Starter
          Zaperlopopotam
          Belgium
          Member #173932
          March 26, 2016
          1309 Posts
          Online
          Posted: July 7, 2016, 4:13 pm - IP Logged

          :)

            retxx's avatar - mrthumbs
            BOSTON
            United States
            Member #48
            September 9, 2001
            3656 Posts
            Offline
            Posted: July 7, 2016, 8:42 pm - IP Logged

            how about someone putting it into an excel spreadsheet so it takes care of any errors.Dupe Alert

              Sunglasses's avatar - nicebear
              Thread Starter
              Zaperlopopotam
              Belgium
              Member #173932
              March 26, 2016
              1309 Posts
              Online
              Posted: July 8, 2016, 2:58 pm - IP Logged

              how about someone putting it into an excel spreadsheet so it takes care of any errors.Dupe Alert

              To prevent you from making errors and knowing that you love to use your browser instead.

              Enter the following URL as location parameter in your browser http://emuis.be/axbm.php .

              Follow the instructions on the page.

              Dance

                retxx's avatar - mrthumbs
                BOSTON
                United States
                Member #48
                September 9, 2001
                3656 Posts
                Offline
                Posted: July 8, 2016, 8:47 pm - IP Logged

                thanks downloaded it and entered the last draw. Should it formulate any digits or not?Banana

                  Sunglasses's avatar - nicebear
                  Thread Starter
                  Zaperlopopotam
                  Belgium
                  Member #173932
                  March 26, 2016
                  1309 Posts
                  Online
                  Posted: July 11, 2016, 6:23 pm - IP Logged

                  Good question.