Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default arithmetic operator ^ means to subtract

arithmetic operator ^ means to subtract
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 348
Default arithmetic operator ^ means to subtract

torie wrote:
arithmetic operator ^ means to subtract


I don't think so. ^ means raise to a power. - means subtract.

Bill
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,651
Default arithmetic operator ^ means to subtract

On Sat, 25 Jul 2009 10:32:01 -0700, torie
wrote:

arithmetic operator ^ means to subtract


Your statement is inaccurate.
What is your question?
--ron
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,059
Default arithmetic operator ^ means to subtract

"Ron Rosenfeld" wrote:
On Sat, 25 Jul 2009 10:32:01 -0700, torie

wrote:
arithmetic operator ^ means to subtract


Your statement is inaccurate.
What is your question?


If I had a rudimentary knowledge of a language, I suspect I would use the
assertive form of verbs even when asking a question. (In fact, I have!)

While it might be relatively easy to translate a verb in one language into
the English verb "to mean", it is a "giant leap for man" to go from there to
"does <something mean ...?".

I assume that Torie meant: "does ^ mean subtract?" Arguably, a better
question would have been: "what does ^ mean in an arithmetic expression?".

As an exercise, try translating that into Swahili ;).

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,346
Default arithmetic operator ^ means to subtract

To clarify what this operator does:

=A1^2

If A1 is 3 then the result is 3 squared or 3*3, the carot, as it is
sometimes called, takes a number to a power.

=A1^3

3 cubed, would equal 3*3*3 = 27

you can also use it as follows:

=A1^(1/3)

if A1 is 27 then this takes the cube root of 27 which is 3. And

=A1^(.5)

If A1 is 64 then this takes the square root which is 8.

=A1-A5 subtracts A5 from A1
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"torie" wrote:

arithmetic operator ^ means to subtract



  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,651
Default arithmetic operator ^ means to subtract

On Sat, 25 Jul 2009 13:41:57 -0700, "JoeU2004" wrote:

If I had a rudimentary knowledge of a language, I suspect I would use the
assertive form of verbs even when asking a question. (In fact, I have!)


If I were speaking the language, I would add an inflection to indicate a
question, and I have.

If I were writing, I would end the sentence with a question mark.

And if I were trying to write a technical question in a non-native language, I
would certainly include my native language.
--ron
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
Date arithmetic Terry Pinnell Excel Discussion (Misc queries) 6 December 31st 08 02:53 PM
About arithmetic Formulas Ravindrapawanbindabinurajendradhamidevfa Excel Discussion (Misc queries) 2 August 13th 06 05:03 PM
Entering arithmetic operation Joseph N. New Users to Excel 3 February 6th 06 03:48 PM
Simple arithmetic Ron Rosenfeld Excel Discussion (Misc queries) 1 January 24th 05 08:35 PM
Simple arithmetic - take 2 Pat Excel Discussion (Misc queries) 1 January 24th 05 08:15 PM


All times are GMT +1. The time now is 10:03 PM.

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

About Us

"It's about Microsoft Excel"