Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Desert Rat
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
flummi
 
Posts: n/a
Default What does the symbol ^ mean in Excel formulas?

3^3 = 27 which means 3 raised to the power of 3

Hans

  #3   Report Post  
Posted to microsoft.public.excel.misc
Max
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
bigwheel
 
Posts: n/a
Default 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?

  #5   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default 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".


  #6   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme
 
Posts: n/a
Default 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?



  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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
  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default What does the symbol ^ mean in Excel formulas?

"--" means
  #9   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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


  #10   Report Post  
Junior Member
 
Posts: 6
Thumbs up

Quote:
Originally Posted by Desert Rat View Post
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"


  #11   Report Post  
Junior Member
 
Posts: 1
Default

http://lq88323.com/
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel: Clear all cell entries EXCEPT formulas? newsgal Excel Discussion (Misc queries) 6 March 18th 06 01:46 AM
Can Excel recognize when data is entered and apply formulas? cwool4512 Excel Worksheet Functions 2 July 7th 05 07:58 PM
Simple formulas in existing Excel 2002 no longer working. AllieB Excel Worksheet Functions 3 May 3rd 05 04:14 PM
Help, Urgent Excel Formulas are not calculating maashoff Excel Discussion (Misc queries) 1 May 3rd 05 12:25 AM
I want Excel to allow cells with formulas and unrelated text blueboy Excel Discussion (Misc queries) 9 March 4th 05 01:22 AM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"