Results 1 to 10 of 10
Thread: Square root in formula (XP)

20050728, 05:58 #1
 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

20050728, 06:02 #2
 Join Date
 Mar 2002
 Posts
 84,353
 Thanks
 0
 Thanked 30 Times in 30 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.

20050728, 16:37 #3
 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!

20050728, 16:57 #4
 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!

20050728, 17:57 #5
 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

20050729, 06:46 #6
 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

20050729, 06:54 #7
 Join Date
 Mar 2002
 Posts
 84,353
 Thanks
 0
 Thanked 30 Times in 30 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.

20050729, 07:09 #8
 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?

20050729, 07:16 #9
 Join Date
 Mar 2002
 Posts
 84,353
 Thanks
 0
 Thanked 30 Times in 30 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.

20050729, 14:55 #10
 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]