Square Root Forumula

[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

 

[Biff]

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

 

[Ron Rosenfeld]

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

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