G
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 ^.
rest of the calc but can't work out the funtion of ^.
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.
M
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
It means raise to the power of so
3^2 = 3 squared = 9
4^.5 is the square root of 4 = 2
Mike
A
ab3d4u
Mike said: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
G
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
=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
P
Peo Sjoblom
If you have a US keyboard it is on the same key as 6
--
Regards,
Peo Sjoblom
--
Regards,
Peo Sjoblom
J
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.