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>

Re: Square root in formula (XP)

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.