ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   arithmetic operator ^ means to subtract (https://www.excelbanter.com/excel-discussion-misc-queries/237995-arithmetic-operator-%5E-means-subtract.html)

torie

arithmetic operator ^ means to subtract
 
arithmetic operator ^ means to subtract

Bill Sharpe

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

Ron Rosenfeld

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

joeu2004

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 ;).


Shane Devenshire[_2_]

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


Ron Rosenfeld

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


All times are GMT +1. The time now is 09:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com