Square Root Forumula

  • Thread starter Thread starter Elizabeth Fodum
  • Start date Start date
E

Elizabeth Fodum

I have a formula that has a square root attached to it eg:
DF=(0.345 x N (square root symbol over the N)) + (0.027 x
N).

Could someone possibly help me regarding this matter, I've
tried the help tool in my Excel but it doesn't come up
with the formula or what i need to do in able to add in
that square root figure.

Much appreciated.

Regards, Liz
 
Hi Liz,

If you're looking for the worksheet function, it's SQRT().
If you're looking for the actual symbol to use in the
equation, goto Insert>Object and select the MS Equation
Editor. I'm using XLXP, don't know if it's available in
earlier versions.

Biff
 
I have a formula that has a square root attached to it eg:
DF=(0.345 x N (square root symbol over the N)) + (0.027 x
N).

Could someone possibly help me regarding this matter, I've
tried the help tool in my Excel but it doesn't come up
with the formula or what i need to do in able to add in
that square root figure.

Much appreciated.

Regards, Liz
Click to expand...

I'm not sure exactly what you are asking. If you mean by "add in a square root
figure" to actually display the square root figure, then you could use the
equation editor. Insert/Object/Microsoft Equation 3.0 will show you how to do
that.

However, if what you want to do is calculate the square root of a number:

If I type "square root" into the HELP line, XL2002 returns the SQRT worksheet
function.

Also, then Nth root of a number x = x^1/N. So the square root of N can be
expressed:

=SQRT(N)

or

=N^(1/2)






--ron
 
Back
Top