| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 ^. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 ^. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 ^. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
