ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   What does the "^" in Excel formulas do? (https://www.excelbanter.com/excel-discussion-misc-queries/148669-what-does-%5E-excel-formulas-do.html)

Rhenier

What does the "^" in Excel formulas do?
 


Bob Phillips

What does the "^" in Excel formulas do?
 
It is 'to the Power of'

2^2 = 4

3^2 = 9

3^3 = 27

etc.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Rhenier" wrote in message
...




David Biddulph[_2_]

What does the "^" in Excel formulas do?
 
Please ask your question in the body of the text, not just in the subject
line. Blank messages will often be rejected by newsreading software or
ignored by contributors to the group.

The ^ symbol raises a number to a power.
=2^3 is =2*2*2 =8
=A1^B1 is equiivalent to =POWER(A1,B1)
--
David Biddulph

"Rhenier" wrote in message
...





All times are GMT +1. The time now is 07:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com