Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8
Default what does the character ^ mean in an excel formula


  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,856
Default what does the character ^ mean in an excel formula

It means "raised to the power of", as in 3 ^ 2 meaning 3 squared.

Hope this helps.

Pete

On Nov 30, 4:31*pm, Jackson wrote:


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default what does the character ^ mean in an excel formula

Next time, please remember to ask the question in the BODY of the message,
not just in the subject line.

=2^4 means 2 to the power 4, or =2*2*2*2 or =POWER(2,4)
--
David Biddulph

"Jackson" wrote in message
...



  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,836
Default what does the character ^ mean in an excel formula

Thats for exponential math; to raise a number to a power.

See this:
http://www.math.com/school/subject2/.../S2U2L2DP.html

More detailed description he
http://en.wikipedia.org/wiki/Exponentiation


HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"David Biddulph" wrote:

Next time, please remember to ask the question in the BODY of the message,
not just in the subject line.

=2^4 means 2 to the power 4, or =2*2*2*2 or =POWER(2,4)
--
David Biddulph

"Jackson" wrote in message
...



.

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 insists on adding character to formula Pierre Excel Worksheet Functions 5 April 1st 09 08:03 PM
USE A WILDCARD CHARACTER IN A FORMULA No_1rebecca Excel Worksheet Functions 3 August 13th 08 08:45 PM
Formula box character needed David Excel Worksheet Functions 2 May 28th 07 11:48 PM
Excel-Match 1st text character in a string to a known character? bushlite Excel Worksheet Functions 2 January 15th 07 06:36 PM
How do I format a character from a result of formula in excel? Mohamed Excel Discussion (Misc queries) 2 December 9th 04 09:43 AM


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

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"