Results 1 to 10 of 10
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Soldotna, Alaska, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Square root in formula (XP)

    Subject edited by HansV - "Excell" wasn't very helpful

    I was wondering how I would write a formula in excell that had a square root in it.
    Example, 29.7 * D2*Square root of 80. I am sure there is a way to do it. I have never tried to use a square root with excell. and in my example I used diameter squred, is it right the way I wrote it for an excell formula? Thanks for all the help <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    Dale

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Square root in formula (XP)

    Excel has a worksheet function SQRT for square root.
    To calculate the square of a number, calculate the number to the power 2.

    Examples:

    A1 contains 9
    =SQRT(A1) results in the square root of A1, i.e. 3.
    =A1^2 results in the square of A1, i.e. 81.

  3. #3
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Soldotna, Alaska, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Square root in formula (XP)

    Thanks a bunch!

  4. #4
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Soldotna, Alaska, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Square root in formula (XP)

    I was able to get it to work but I am having problems writing this formula so it will work. I want to write this formula, 29.7 x diameter squared X the square root of 80.

    I tried this =A1=power =SQRT(C1)
    any help would be greatly appreciated!

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Square root in formula (XP)

    I am not sure what you meant A1 and C1 to contain from the way you tried to write the formula. If A1 contains the diameter, then the formula should look something like this:

    <code>
    =29.7*(A1^2)*SQRT(80)
    </code>
    Legare Coleman

  6. #6
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Soldotna, Alaska, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Square root in formula (XP)

    A1 is the first cell on the spread sheet. so I guess I am asking if I can write a formula for this and have the spread sheet automatically calculate what I put into the cells.

    29.7 x Diameter squared X the sqare root of any number. What I want to do is be able to put the numbers in the spread sheet and have it calculate my answer.

    Thank you for your time,
    Dale

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Square root in formula (XP)

    Say that you enter the diameter in A2 and "any number" in B2. The formula

    =29.7*A2^2*SQRT(B2)

    in C2 will calculate 29.7 x (diameter squared) x (square root of any number):

    <table border=1><td></td><td align=center>A</td><td align=center>B</td><td align=center>C</td><td align=center>1</td><td>Diameter</td><td>Any Number</td><td>Output</td><td align=center>2</td><td align=right>3</td><td align=right>4</td><td align=right>534.6</td></table>
    If this is not what you want, please provide a detailed description of what you want, and/or attach a dummy workbook.

  8. #8
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Soldotna, Alaska, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Square root in formula (XP)

    Thnaks for all the help. is this right?

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Square root in formula (XP)

    The label in C1 is confusing. C2 doesn't contain "The square root of any number", it contains a number whose square root is calculated in the formula.
    If you want to include A2 in the formula, i.e. if you want to be able to enter another number than 29.7 and have the result be adjusted automatically, change the formula to

    =A2*B2^2*SQRT(C2)

    Whenever you type/edit a value in either A2, B2 or C2, the result in D2 will be recalculated.

  10. #10
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Soldotna, Alaska, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Square root in formula (XP)

    OUTSTANDING THANKS FOR ALL THE HELP [img]/forums/images/smilies/smile.gif[/img]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •