What is ^ in a formula? Thanks.

"Andrianna" wrote in message
oups.com...
What is ^ in a formula? Thanks.

Raised to a power.
2^5 is 2 to the power 5 (sometimes also written as 2**5) =2*2*2*2*2.
--
David Biddulph

Andrianna wrote:
What is ^ in a formula? Thanks.

Hi Andrianna,

The number infront of ^ is raised to the power of the number after the
^.

So:

=2^8 = 256

Regardes,
Bondi

The ^ symbol is used to show exponents. So, 2^2 would be the same as 2
squared or 2² and 15^3 would be 15 cubed or 15³.

HTH,
Elkar

"Andrianna" wrote:

What is ^ in a formula? Thanks.

David,

Doesn't =2**5 equate to =2*10^5 rather than =2^5?

--
Regards,

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"David Biddulph" wrote in message
...
"Andrianna" wrote in message
oups.com...
What is ^ in a formula? Thanks.

Raised to a power.
2^5 is 2 to the power 5 (sometimes also written as 2**5) =2*2*2*2*2.
--
David Biddulph

"Sandy Mann" wrote in message
...
David,

Doesn't =2**5 equate to =2*10^5 rather than =2^5?

In Excel it seems to be interpreted that way (to my surprise, I'll admit).
[I notice that Excel won't accept =A1**B1, but if you use 2**5 when typing a
data value it will interpret it the way you suggest.]

.... but more generally 2**5 is 2^5.

Try http://www.google.com/search?q=2**5 and you'll see that it gives the
answer 32.
--
David Biddulph