In excel what does the symbol ^ represent
 

Have recieved a spreadsheet with the ^ in a cell.

What does this do?

In excel what does the symbol ^ represent
 

Hi,

It's the mathmatical operator meaning 'raise to the power' of:

3^3= 3 raised to the power of 3 = 27

0r 9^.5 is another way of getting the square root of 9 =3


Mike

"GeorgeD" wrote:

Have recieved a spreadsheet with the ^ in a cell.

What does this do?

In excel what does the symbol ^ represent
 

A1^B1 means A1 raised to the power of B1
2^5 is 2 to the power 5, or 2*2*2*2*2 (=32)

A1^B1 is the same as POWER(A1,B1)

In some computer languages, the symbol ** is used for the same purpose as ^
is in Excel.
--
David Biddulph

"GeorgeD" wrote in message
...
Have recieved a spreadsheet with the ^ in a cell.

What does this do?

In excel what does the symbol ^ represent
 

Hi,

To raise a number to a power, use the "^" operator or the POWER function.

Example

A B
1. Formula Description (Result)
2. =POWER(5,2) Calculates five squared (25)
3. =5^3 Calculates five cubed (125)

Challa Prabhu

"GeorgeD" wrote:

Have recieved a spreadsheet with the ^ in a cell.

What does this do?