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
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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks