# Thread: Square root in formula (XP)

1. ## 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. ## 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. ## Re: Square root in formula (XP)

Thanks a bunch!

4. ## 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. ## 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>

6. ## 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. ## 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. ## Re: Square root in formula (XP)

Thnaks for all the help. is this right?

9. ## 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. ## 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
•