ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   what does ^ mean in an excel formula? (https://www.excelbanter.com/excel-discussion-misc-queries/177285-what-does-%5E-mean-excel-formula.html)

gabbygirl

what does ^ mean in an excel formula?
 
I am trying to figure out a formula and it uses the ^ character in it, what
does this mean?

joeu2004

what does ^ mean in an excel formula?
 
On Feb 20, 8:50*am, gabbygirl
wrote:
I am trying to figure out a formula and it uses the ^ character
in it, what does this mean?


"To the power of" -- exponentiation. 2^3 means 2 cubed, which is 8.

For a brief description of Excel operators, go to Help Excel Help
(F1), type "operators" in the search field, and click on "about
calculation operators".


Ed Cones

what does ^ mean in an excel formula?
 
Raises a number to a power. =2^2 would return 4, for instance.

"gabbygirl" wrote:

I am trying to figure out a formula and it uses the ^ character in it, what
does this mean?


David Biddulph[_2_]

what does ^ mean in an excel formula?
 
=2^3 is 2 raised to the power of 3, or =2*2*2, or =POWER(2,3)
--
David Biddulph

"gabbygirl" wrote in message
...
I am trying to figure out a formula and it uses the ^ character in it, what
does this mean?





All times are GMT +1. The time now is 10:29 AM.

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