What value does ^ have in Excel?
 

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 ^.

What value does ^ have in Excel?
 

Hi,

It means raise to the power of so

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

Mike

"Graham Ingram" wrote:

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 ^.

What value does ^ have in Excel?
 

Mike H;2509917 Wrote:
Hi,

It means raise to the power of so

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

Mike

"Graham Ingram" wrote:
-
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




--
ab3d4u

What value does ^ have in Excel?
 

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
wrote:

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 ^.

What value does ^ have in Excel?
 

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


--


Regards,


Peo Sjoblom


"ab3d4u" wrote in message
...

Mike H;2509917 Wrote:
Hi,

It means raise to the power of so

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

Mike

"Graham Ingram" wrote:
-
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




--
ab3d4u

What value does ^ have in Excel?
 

On Dec 3, 9:39 am, ab3d4u
wrote:
Mike H;2509917 Wrote:
It means raise to the power of so
3^2 = 3 squared = 9
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.