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

Requesting Excel Help, Please

Topic closed. 6 replies. Last post 9 years ago by kitsmith.

Page 1 of 1
PrintE-mailLink
Avatar
Sunny California
United States
Member #40295
May 31, 2006
7712 Posts
Offline
Posted: June 13, 2007, 9:12 am - IP Logged

I am trying to make a chart of every pick 3 number and it's square root. However, I would like to go beyond the first set of numbers it gives me.

For example, on my calculator if I punch in 458 and then it's square root, I can keep pressing the square root button and it will keep giving me calculations.

Any way to do this on Excel?

Appreciate any input and help, thanks so much!

    time*treat's avatar - radar

    United States
    Member #13130
    March 30, 2005
    2171 Posts
    Offline
    Posted: June 13, 2007, 11:10 am - IP Logged

    if you have 458 in row 1, col 1; in row 1 col 2 type =RC[-1]^0.5

    you can drag & drop that formula into other columns on row 1

    In neo-conned Amerika, bank robs you.
    Alcohol, Tobacco, and Firearms should be the name of a convenience store, not a govnoment agency.

      Avatar
      Sunny California
      United States
      Member #40295
      May 31, 2006
      7712 Posts
      Offline
      Posted: June 13, 2007, 11:28 am - IP Logged

      Thanks for responding,time*treat!

      I think I'm doing something wrong,though. I punched in your formula in the second col but it just stays there and doesn't forumlate anything. Shouldn't it change into something? Thanks!

        CARBOB's avatar - FL LOTTERY_LOGO.png
        ORLANDO, FLORIDA
        United States
        Member #4924
        June 3, 2004
        5912 Posts
        Online
        Posted: June 13, 2007, 11:54 am - IP Logged

        I am trying to make a chart of every pick 3 number and it's square root. However, I would like to go beyond the first set of numbers it gives me.

        For example, on my calculator if I punch in 458 and then it's square root, I can keep pressing the square root button and it will keep giving me calculations.

        Any way to do this on Excel?

        Appreciate any input and help, thanks so much!

         Brenda, are you saying, you want to take the square root of 458 ,then take the square root of the square root? If so, if your data(458) is in A1, in A2 type =SQRT(A1), ENTER, Then drag that cell across your page.

         

         

        45821.400934559 4.6261144132.1508403971.4665743751.2110220371.1004644641.0490302491.0242217771.012038427
          Avatar
          Sunny California
          United States
          Member #40295
          May 31, 2006
          7712 Posts
          Offline
          Posted: June 13, 2007, 12:03 pm - IP Logged

           Brenda, are you saying, you want to take the square root of 458 ,then take the square root of the square root? If so, if your data(458) is in A1, in A2 type =SQRT(A1), ENTER, Then drag that cell across your page.

           

           

          45821.400934559 4.6261144132.1508403971.4665743751.2110220371.1004644641.0490302491.0242217771.012038427

          That's it exactly,Bob! I will try this, thanks a million!

            Avatar
            NASHVILLE, TENN
            United States
            Member #33372
            February 20, 2006
            1044 Posts
            Offline
            Posted: July 12, 2007, 6:34 pm - IP Logged

            I am trying to make a chart of every pick 3 number and it's square root. However, I would like to go beyond the first set of numbers it gives me.

            For example, on my calculator if I punch in 458 and then it's square root, I can keep pressing the square root button and it will keep giving me calculations.

            Any way to do this on Excel?

            Appreciate any input and help, thanks so much!

                We need a computer forum


              United States
              Member #53586
              July 12, 2007
              1 Posts
              Offline
              Posted: July 12, 2007, 7:34 pm - IP Logged

                  We need a computer forum

              Better yet, an Excel forum . . . or generic spreadsheet forum.Emoticons