+ Reply to Thread
Results 1 to 5 of 5

Unknown Formula

  1. #1
    Lucky_guy2000
    Guest

    Unknown Formula

    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


  2. #2
    Santhosh Kumar
    Guest

    Re: Unknown Formula

    Hi,

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


  3. #3
    Ron Coderre
    Guest

    RE: Unknown Formula

    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
    >


  4. #4
    SVC
    Guest

    RE: Unknown Formula

    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
    >


  5. #5
    Lucky_guy2000
    Guest

    RE: Unknown Formula

    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
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1