In excel what does the symbol ^ represent

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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.
 
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
 
Back
Top