A
Andrianna
What is ^ in a formula? Thanks.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
David Biddulph
Andrianna said: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.
B
Bondi
Andrianna said: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
E
Elkar
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
squared or 2² and 15^3 would be 15 cubed or 15³.
HTH,
Elkar
S
Sandy Mann
David,
Doesn't =2**5 equate to =2*10^5 rather than =2^5?
--
Regards,
Sandy
In Perth, the ancient capital of Scotland
[email protected]
[email protected] with @tiscali.co.uk
Doesn't =2**5 equate to =2*10^5 rather than =2^5?
--
Regards,
Sandy
In Perth, the ancient capital of Scotland
[email protected]
[email protected] with @tiscali.co.uk
D
David Biddulph
Sandy Mann said: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.