What value does ^ have in Excel?

[Graham Ingram]

I've inherited a spread sheed with a calculation using ^2. I understand the
rest of the calc but can't work out the funtion of ^.

 

[Mike H]

Hi,

It means raise to the power of so

3^2 = 3 squared = 9
4^.5 is the square root of 4 = 2

Mike

 

[ab3d4u]

Hi,

It means raise to the power of so

3^2 = 3 squared = 9
4^.5 is the square root of 4 = 2

Mike

:
-
I've inherited a spread sheed with a calculation using ^2. I
understand the
rest of the calc but can't work out the funtion of ^.-

Mike- thanks for your help. I also inherited a file with this
character. Till now I did not knew what it does. My Q is how do you
write this function? It is not in the key board. I am using Excel 2007.
While you are at it, could you please tell me where I should start my
replies or questions not initiated by me?
Have a nice day

 

[Gord Dibben]

That is a quick way of raising a number exponentially.

=4^2 returns 16 which is 4 squared.


Gord Dibben MS Excel MVP

On Mon, 3 Dec 2007 07:36:15 -0800, Graham Ingram <Graham

 

[Peo Sjoblom]

If you have a US keyboard it is on the same key as 6


--


Regards,


Peo Sjoblom

 

[joeu2004]

My Q is how do you write this function? It is not in the key board.

On a US keyboard, it is shift-6. If you really do not have it
anywhere on your keyboard (surprise!), I suppose you could use the
POWER() function (sigh). POWER(3,2) is the same as 3^2.