ExcelBanter

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

Desert Rat

What does the symbol ^ mean in Excel formulas?
 
I am having trouble finding out the purpose of the symbol ^ when using
calculations in Excel. Can anyone help me?

flummi

What does the symbol ^ mean in Excel formulas?
 
3^3 = 27 which means 3 raised to the power of 3

Hans


Max

What does the symbol ^ mean in Excel formulas?
 
Caret: "^" means "to the power of"

Eg: entering in say, A1: =3^4
means to evaluate 3 to the power of 4
i.e: =3x3x3x3=81

Likewise =2^3 = 2x2x2=8
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Desert Rat" <Desert wrote in message
...
I am having trouble finding out the purpose of the symbol ^ when using
calculations in Excel. Can anyone help me?




bigwheel

What does the symbol ^ mean in Excel formulas?
 
It means "raise to the power of" so that 2^3 means 2 raised to the power of 3
(or 2 cubed) which equals 8

"Desert Rat" wrote:

I am having trouble finding out the purpose of the symbol ^ when using
calculations in Excel. Can anyone help me?


[email protected]

What does the symbol ^ mean in Excel formulas?
 
"Desert Rat" wrote:
I am having trouble finding out the purpose of the
symbol ^ when using calculations in Excel. Can
anyone help me?


For future reference, use the key phrase "calculation operators"
in a Help search, and see the Help page "about calculation
operators".

Bernard Liengme

What does the symbol ^ mean in Excel formulas?
 
You got lots of good answers but if you need another:
The one-word name for the ^ operator is "exponentiation"
just as + is addition, × is multiplication.....
For confirmation of this lovely geek work, see
http://en.wikipedia.org/wiki/Exponentiation
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Desert Rat" <Desert wrote in message
...
I am having trouble finding out the purpose of the symbol ^ when using
calculations in Excel. Can anyone help me?




[email protected]

What does the symbol ^ mean in Excel formulas?
 
On Saturday, February 11, 2006 5:31:27 PM UTC+5:30, Desert Rat wrote:
I am having trouble finding out the purpose of the symbol ^ when using
calculations in Excel. Can anyone help me?


GOOD

[email protected]

What does the symbol ^ mean in Excel formulas?
 
"--" means

Stephen Wolstenholme[_4_]

What does the symbol ^ mean in Excel formulas?
 
On Sat, 19 Sep 2015 05:26:07 -0700 (PDT),
wrote:

"--" means


+

Steve

--
Neural Network Software for Windows
http://www.npsnn.com

EasyNN-plus More than just a neural network http://www.easynn.com



driller3_banter

Quote:

Originally Posted by Desert Rat (Post 239597)
I am having trouble finding out the purpose of the symbol ^ when using
calculations in Excel. Can anyone help me?

below is also a positive short form for square root
"=sqrt(9)" is also "=9^0.5"

profilmuoiba13

http://lq88323.com/


All times are GMT +1. The time now is 03:05 AM.

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