Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what does the "carat" character mean in Excel - answer
Jackson -
I can't reply to your posting directly - I suspect the "^" character in your posting subject may be the culprit. To answer your question, the carat represents a 'to the power of' operation. That is x^2 means x squared (x times itself). y^3 means y cubed (y times y times y). Hope that helps! -- Daryl S |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what does the "carat" character mean in Excel - answer
Daryl,
it's probably something to do with the browser that you use to access the newsgroups. If a poster does not expand on his heading for the thread and use the message body, then some browsers do not allow you to respond to it. Hope this helps. Pete On Nov 30, 5:38*pm, Daryl S wrote: Jackson - I can't reply to your posting directly - I suspect the "^" character in your posting subject may be the culprit. To answer your question, the carat represents a 'to the power of' operation. *That is x^2 means x squared (x times itself). * y^3 means y cubed (y times y times y). Hope that helps! -- Daryl S |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what does the "carat" character mean in Excel - answer
Daryl,
You are correct but need to add that ^ is called the exponentiation operator best wishes -- Bernard Liengme http://people.stfx.ca/bliengme Microsoft Excel MVP "Daryl S" wrote in message ... Jackson - I can't reply to your posting directly - I suspect the "^" character in your posting subject may be the culprit. To answer your question, the carat represents a 'to the power of' operation. That is x^2 means x squared (x times itself). y^3 means y cubed (y times y times y). Hope that helps! -- Daryl S |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what does the "carat" character mean in Excel - answer
One would think it would be a simple matter to have some sort of check to
make sure a poster puts something in the body of the message, or have it default to "no text"... Until then, we can only hope people will one day learn the difference between "subject" and "message". -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Pete_UK" wrote: Daryl, it's probably something to do with the browser that you use to access the newsgroups. If a poster does not expand on his heading for the thread and use the message body, then some browsers do not allow you to respond to it. Hope this helps. Pete On Nov 30, 5:38 pm, Daryl S wrote: Jackson - I can't reply to your posting directly - I suspect the "^" character in your posting subject may be the culprit. To answer your question, the carat represents a 'to the power of' operation. That is x^2 means x squared (x times itself). y^3 means y cubed (y times y times y). Hope that helps! -- Daryl S . |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what does the "carat" character mean in Excel - answer
"Pete_UK" wrote:
it's probably something to do with the browser that you use to access the newsgroups. Hmm, I always thought it was simply yet-another thing that is wrong with the MS Discussion Groups web interface, independent of the browser. For example, using IE6 to respond to the original subject-only posting via MSDG and Google Groups, I have no problem creating a response using GG. It is only MSDG that fails. I am unable to test my theory using Firefox because I cannot even log into MSDG using FF. (That might be an intermittent problem with the MSDG service. Now, I am getting Service Unavailable errors with both IE6 and FF.) ----- original message ----- "Pete_UK" wrote in message ... Daryl, it's probably something to do with the browser that you use to access the newsgroups. If a poster does not expand on his heading for the thread and use the message body, then some browsers do not allow you to respond to it. Hope this helps. Pete On Nov 30, 5:38 pm, Daryl S wrote: Jackson - I can't reply to your posting directly - I suspect the "^" character in your posting subject may be the culprit. To answer your question, the carat represents a 'to the power of' operation. That is x^2 means x squared (x times itself). y^3 means y cubed (y times y times y). Hope that helps! -- Daryl S |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what does the "carat" character mean in Excel - answer
On Nov 30, 12:38*pm, Daryl S wrote:
Jackson - I can't reply to your posting directly - I suspect the "^" character in your posting subject may be the culprit. To answer your question, the carat represents a 'to the power of' operation. *That is x^2 means x squared (x times itself). * y^3 means y cubed (y times y times y). Hope that helps! -- Daryl S Hi All! I'm read thru the thread here and still don't quite understand the double carat use of "^^". Please advise. Thanks, Matty |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what does the "carat" character mean in Excel - answer
Double caret ^^ does nothing.
=2^^3 throws an error. Maybe you meant to type =2^3^4 which is same as =2^12 Where have you seen a double caret ^^ used? I sometimes use ^^ in an editreplace operation. EditReplace What: = With: ^^ Replace all. I will do this when I want to copy linked formulas from one workbook to another without creating a link to source workbook. Gord Dibben MS Excel MVP On Mon, 21 Dec 2009 10:16:01 -0800 (PST), fullgale1 wrote: On Nov 30, 12:38*pm, Daryl S wrote: Jackson - I can't reply to your posting directly - I suspect the "^" character in your posting subject may be the culprit. To answer your question, the carat represents a 'to the power of' operation. *That is x^2 means x squared (x times itself). * y^3 means y cubed (y times y times y). Hope that helps! -- Daryl S Hi All! I'm read thru the thread here and still don't quite understand the double carat use of "^^". Please advise. Thanks, Matty |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what does the "carat" character mean in Excel - answer
Hi Gord,
I saw a post the other day where someone was suggesting a formula using SUBSTITUTE to replace a space with 2 carets - presumably because this is a character sequence that one would not normally encounter - similar to your Find & replace example. Maybe fullgale1 saw that same post. Pete On Dec 21, 7:47*pm, Gord Dibben <gorddibbATshawDOTca wrote: Double caret ^^ does nothing. =2^^3 * throws an error. Maybe you meant to type *=2^3^4 *which is same as *=2^12 Where have you seen a double caret ^^ used? I sometimes use ^^ in an editreplace operation. EditReplace What: *= With: *^^ Replace all. I will do this when I want to copy linked formulas from one workbook to another without creating a link to source workbook. Gord Dibben *MS Excel MVP On Mon, 21 Dec 2009 10:16:01 -0800 (PST), fullgale1 wrote: On Nov 30, 12:38*pm, Daryl S wrote: Jackson - I can't reply to your posting directly - I suspect the "^" character in your posting subject may be the culprit. To answer your question, the carat represents a 'to the power of' operation. *That is x^2 means x squared (x times itself). * y^3 means y cubed (y times y times y). Hope that helps! -- Daryl S Hi All! I'm read thru the thread here and still don't quite understand the double carat use of "^^". Please advise. Thanks, Matty- Hide quoted text - - Show quoted text - |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what does the "carat" character mean in Excel - answer
Very true............I have seen that particular ^^ used with the SUBSTITUTE
function. Gord On Mon, 21 Dec 2009 17:17:45 -0800 (PST), Pete_UK wrote: Hi Gord, I saw a post the other day where someone was suggesting a formula using SUBSTITUTE to replace a space with 2 carets - presumably because this is a character sequence that one would not normally encounter - similar to your Find & replace example. Maybe fullgale1 saw that same post. Pete On Dec 21, 7:47*pm, Gord Dibben <gorddibbATshawDOTca wrote: Double caret ^^ does nothing. =2^^3 * throws an error. Maybe you meant to type *=2^3^4 *which is same as *=2^12 Where have you seen a double caret ^^ used? I sometimes use ^^ in an editreplace operation. EditReplace What: *= With: *^^ Replace all. I will do this when I want to copy linked formulas from one workbook to another without creating a link to source workbook. Gord Dibben *MS Excel MVP On Mon, 21 Dec 2009 10:16:01 -0800 (PST), fullgale1 wrote: On Nov 30, 12:38*pm, Daryl S wrote: Jackson - I can't reply to your posting directly - I suspect the "^" character in your posting subject may be the culprit. To answer your question, the carat represents a 'to the power of' operation. *That is x^2 means x squared (x times itself). * y^3 means y cubed (y times y times y). Hope that helps! -- Daryl S Hi All! I'm read thru the thread here and still don't quite understand the double carat use of "^^". Please advise. Thanks, Matty- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to put special character "&" in Excel Header / Footer ? | Excel Discussion (Misc queries) | |||
VLOOKUP displaying "NO ANSWER" instead of "0" | Excel Worksheet Functions | |||
How do I write an excel formula with a text answer ("yes" or "no") | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |