| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What does the symbol ^ mean in Excel formulas?
3^3 = 27 which means 3 raised to the power of 3
Hans |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What does the symbol ^ mean in Excel formulas?
"--" means
|
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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". |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#10
|
|||
|
|||
Quote:
"=sqrt(9)" is also "=9^0.5" |
|
#11
|
|||
|
|||
|
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: Clear all cell entries EXCEPT formulas? | Excel Discussion (Misc queries) | |||
| Can Excel recognize when data is entered and apply formulas? | Excel Worksheet Functions | |||
| Simple formulas in existing Excel 2002 no longer working. | Excel Worksheet Functions | |||
| Help, Urgent Excel Formulas are not calculating | Excel Discussion (Misc queries) | |||
| I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) | |||
Hybrid Mode
