Welcome Guest
Log In | Register )
You last visited December 4, 2016, 9:15 am
All times shown are
Eastern Time (GMT-5:00)

formula for spead sheet excell

Topic closed. 7 replies. Last post 10 years ago by Raven62.

Page 1 of 1
PrintE-mailLink
Avatar
Mount Morris
United States
Member #46750
September 27, 2006
139 Posts
Offline
Posted: January 14, 2007, 11:09 am - IP Logged

I am wanting to put 4 digit in it  4567  and then devide it by square root .to get answer

6757958271 so I can back test Nbey6 system faster it had the 808 last night st here in Mi 

    Avatar

    United States
    Member #33295
    February 19, 2006
    699 Posts
    Offline
    Posted: January 14, 2007, 4:48 pm - IP Logged

    I am wanting to put 4 digit in it  4567  and then devide it by square root .to get answer

    6757958271 so I can back test Nbey6 system faster it had the 808 last night st here in Mi 

    If 4567 is in cell A1 enter

    =SQRT(A1)  in cell A2 or whatever cell you want it in.

    And if 4567 is in a different cell replace (A1) with that cell number.

    Isabel, you are going to feel very silly when this turns out to be make-believe.

      Avatar

      United States
      Member #41846
      June 23, 2006
      458 Posts
      Offline
      Posted: January 14, 2007, 4:48 pm - IP Logged

      hillbilly

      assume your number is in a1   now format b1 to be # of character you want in this case 8

      in cell b1  enter this formula   =int(sqrt(a1)*1000000)

      you should have a 8 digit number no decimal

      in cell c1   =left(b1,3)

      in cell d1   =right(b1,3)

       

      c1 and d1 have you numbers

       

      some of these steps could be combined but this way you can see the steps

      p8 

        winsumloosesum's avatar - Lottery-060.jpg
        Pennsylvania
        United States
        Member #2218
        September 1, 2003
        5387 Posts
        Online
        Posted: January 15, 2007, 10:57 am - IP Logged

        hillbilly

        assume your number is in a1   now format b1 to be # of character you want in this case 8

        in cell b1  enter this formula   =int(sqrt(a1)*1000000)

        you should have a 8 digit number no decimal

        in cell c1   =left(b1,3)

        in cell d1   =right(b1,3)

         

        c1 and d1 have you numbers

         

        some of these steps could be combined but this way you can see the steps

        p8 

        Links to Pick 3 and Pick 4 Square Root Conversion Charts

        I'm not sure if all the conversions are correct.

        Excel File Download LinK

        http://rapidshare.com/files/11831779/P3_and_P4_SQRT_Conversions.xls

        Text File Links:

        http://rapidshare.com/files/11831967/Pick_3_SQRT.txt

        http://rapidshare.com/files/11831968/Pick_4_SQRT.txt 

          Raven62's avatar - binary
          New Jersey
          United States
          Member #17843
          June 28, 2005
          49657 Posts
          Online
          Posted: January 15, 2007, 2:33 pm - IP Logged

          Links to Pick 3 and Pick 4 Square Root Conversion Charts

          I'm not sure if all the conversions are correct.

          Excel File Download LinK

          http://rapidshare.com/files/11831779/P3_and_P4_SQRT_Conversions.xls

          Text File Links:

          http://rapidshare.com/files/11831967/Pick_3_SQRT.txt

          http://rapidshare.com/files/11831968/Pick_4_SQRT.txt 

          WSLS,

          The 2 text files are the same: Are they suppose to be?

          A mind once stretched by a new idea never returns to its original dimensions!

            winsumloosesum's avatar - Lottery-060.jpg
            Pennsylvania
            United States
            Member #2218
            September 1, 2003
            5387 Posts
            Online
            Posted: January 16, 2007, 6:02 am - IP Logged

            WSLS,

            The 2 text files are the same: Are they suppose to be?

            I'll correct them today.

            Sorry!! 

              winsumloosesum's avatar - Lottery-060.jpg
              Pennsylvania
              United States
              Member #2218
              September 1, 2003
              5387 Posts
              Online
              Posted: January 16, 2007, 9:11 am - IP Logged

              Pick 3 Square Root Text file download link:

              http://rapidshare.com/files/11965403/Pick_3_SQRT.txt 

                Raven62's avatar - binary
                New Jersey
                United States
                Member #17843
                June 28, 2005
                49657 Posts
                Online
                Posted: January 16, 2007, 9:27 am - IP Logged

                Pick 3 Square Root Text file download link:

                http://rapidshare.com/files/11965403/Pick_3_SQRT.txt 

                Thank You! Thumbs Up

                A mind once stretched by a new idea never returns to its original dimensions!