I am working on correcting links and formulas on an inherited worksheet and
came across the following formula:

=35*B3*(B11+3000)^0.5

I do not understand the purpose of ^0.5. Can anyone help?

Thanks.
Johnnie

Hi,

^ symbol indicates the power of (B11+3000).
Exaple: 10^2=100

The caret (^) indicates that the following number is an exponent.

^0.5 = ^1/2 = Square Root

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Lucky_guy2000" wrote:

I am working on correcting links and formulas on an inherited worksheet and
came across the following formula:

=35*B3*(B11+3000)^0.5

I do not understand the purpose of ^0.5. Can anyone help?

Thanks.
Johnnie

The ^0.5 means find the square root (i.e., the 1/2 power). It could
alternately be written ^(1/2).

"Lucky_guy2000" wrote:

I am working on correcting links and formulas on an inherited worksheet and
came across the following formula:

=35*B3*(B11+3000)^0.5

I do not understand the purpose of ^0.5. Can anyone help?

Thanks.
Johnnie

Thanks everyone for the response. I now understand what it means, now I just
have to find from the originator why. Once again, thanks all.
Johnnie

"Lucky_guy2000" wrote:

I am working on correcting links and formulas on an inherited worksheet and
came across the following formula:

=35*B3*(B11+3000)^0.5

I do not understand the purpose of ^0.5. Can anyone help?

Thanks.
Johnnie