What does a ^ symbol mean used in a formula
 

What does a ^ symbol mean used in a formula
 

It means "to the power of".

10^3 = 10 to the 3rd power = 10*10*10 = 1000

Biff

"timbrook" wrote in message
...

What does a ^ symbol mean used in a formula
 

"timbrook" wrote in message
...


Since I deplore the use of the subject as the only text in a
post, I will say RTFM....calculation operators.



--
James Silverton
Potomac, Maryland

What does a ^ symbol mean used in a formula
 

Most common usage is to produce an exponential value.

=2^3 returns 8

Same as =2x2x2


Gord Dibben MS Excel MVP

On Thu, 5 Oct 2006 14:14:02 -0700, timbrook
wrote:

What does a ^ symbol mean used in a formula
 

It's a short question.

"James Silverton" wrote:

"timbrook" wrote in message
...


Since I deplore the use of the subject as the only text in a
post, I will say RTFM....calculation operators.



--
James Silverton
Potomac, Maryland

What does a ^ symbol mean used in a formula
 

The other possibility is that it is the or operator in an array formula (but
that is quite a bit less common)...
--
HTH...

Jim Thomlinson


"Gord Dibben" wrote:

Most common usage is to produce an exponential value.

=2^3 returns 8

Same as =2x2x2


Gord Dibben MS Excel MVP

On Thu, 5 Oct 2006 14:14:02 -0700, timbrook
wrote:

What does a ^ symbol mean used in a formula
 

I've seen a plus for this. You sure it was the caret?



Jim Thomlinson wrote:

The other possibility is that it is the or operator in an array formula (but
that is quite a bit less common)...
--
HTH...

Jim Thomlinson

"Gord Dibben" wrote:

Most common usage is to produce an exponential value.

=2^3 returns 8

Same as =2x2x2


Gord Dibben MS Excel MVP

On Thu, 5 Oct 2006 14:14:02 -0700, timbrook
wrote:




--

Dave Peterson

What does a ^ symbol mean used in a formula
 

That's a new one on me!

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Jim Thomlinson" wrote in message
...
The other possibility is that it is the or operator in an array formula
(but
that is quite a bit less common)...
--
HTH...

Jim Thomlinson


"Gord Dibben" wrote:

Most common usage is to produce an exponential value.

=2^3 returns 8

Same as =2x2x2


Gord Dibben MS Excel MVP

On Thu, 5 Oct 2006 14:14:02 -0700, timbrook

wrote:

What does a ^ symbol mean used in a formula
 

When was the last time Excel shipped with a manual?

Time to update the saying!

Biff

"Ricter" wrote in message
...
It's a short question.

"James Silverton" wrote:

"timbrook" wrote in message
...


Since I deplore the use of the subject as the only text in a
post, I will say RTFM....calculation operators.



--
James Silverton
Potomac, Maryland

What does a ^ symbol mean used in a formula
 

"Biff" wrote in message
...
When was the last time Excel shipped with a manual?

Time to update the saying!

Biff

These days the nearest approach to a manual is HELP but I did
not want to spell things out completely:-) Don't you think
people should use help?



--
James Silverton
Potomac, Maryland

What does a ^ symbol mean used in a formula
 

RTFM is common vernacular now, I doubt that anyone thinks that it means go
and get a physical entity.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Biff" wrote in message
...
When was the last time Excel shipped with a manual?

Time to update the saying!

Biff

"Ricter" wrote in message
...
It's a short question.

"James Silverton" wrote:

"timbrook" wrote in message
...


Since I deplore the use of the subject as the only text in a
post, I will say RTFM....calculation operators.



--
James Silverton
Potomac, Maryland

What does a ^ symbol mean used in a formula
 

Ooops... Yes it is the + symbol... I am not getting a lot of sleep lately...
I am a new Dad (second time round) so I am running on fumes at the moment...
--
HTH...

Jim Thomlinson


"Bob Phillips" wrote:

That's a new one on me!

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Jim Thomlinson" wrote in message
...
The other possibility is that it is the or operator in an array formula
(but
that is quite a bit less common)...
--
HTH...

Jim Thomlinson


"Gord Dibben" wrote:

Most common usage is to produce an exponential value.

=2^3 returns 8

Same as =2x2x2


Gord Dibben MS Excel MVP

On Thu, 5 Oct 2006 14:14:02 -0700, timbrook

wrote:

What does a ^ symbol mean used in a formula
 

Now I remember where I got that from. It is C/C++ syntax... Not to sure where
my brain pulled that from.
--
HTH...

Jim Thomlinson


"Jim Thomlinson" wrote:

Ooops... Yes it is the + symbol... I am not getting a lot of sleep lately...
I am a new Dad (second time round) so I am running on fumes at the moment...
--
HTH...

Jim Thomlinson


"Bob Phillips" wrote:

That's a new one on me!

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Jim Thomlinson" wrote in message
...
The other possibility is that it is the or operator in an array formula
(but
that is quite a bit less common)...
--
HTH...

Jim Thomlinson


"Gord Dibben" wrote:

Most common usage is to produce an exponential value.

=2^3 returns 8

Same as =2x2x2


Gord Dibben MS Excel MVP

On Thu, 5 Oct 2006 14:14:02 -0700, timbrook

wrote:

What does a ^ symbol mean used in a formula
 

Congrats on the second baby.

If I could think of some math expression that made sense, I'd put it here!



Jim Thomlinson wrote:

Ooops... Yes it is the + symbol... I am not getting a lot of sleep lately...
I am a new Dad (second time round) so I am running on fumes at the moment...
--
HTH...

Jim Thomlinson

"Bob Phillips" wrote:

That's a new one on me!

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Jim Thomlinson" wrote in message
...
The other possibility is that it is the or operator in an array formula
(but
that is quite a bit less common)...
--
HTH...

Jim Thomlinson


"Gord Dibben" wrote:

Most common usage is to produce an exponential value.

=2^3 returns 8

Same as =2x2x2


Gord Dibben MS Excel MVP

On Thu, 5 Oct 2006 14:14:02 -0700, timbrook

wrote:







--

Dave Peterson

What does a ^ symbol mean used in a formula
 

Maybe

(1 +1 + ¹ ) + ¹ = 2 + 2(¹) + <vbg

Congratulations Jim.

--
Regards

Roger Govier


"Dave Peterson" wrote in message
...
Congrats on the second baby.

If I could think of some math expression that made sense, I'd put it
here!



Jim Thomlinson wrote:

Ooops... Yes it is the + symbol... I am not getting a lot of sleep
lately...
I am a new Dad (second time round) so I am running on fumes at the
moment...
--
HTH...

Jim Thomlinson

"Bob Phillips" wrote:

That's a new one on me!

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Jim Thomlinson" wrote in
message
...
The other possibility is that it is the or operator in an array
formula
(but
that is quite a bit less common)...
--
HTH...

Jim Thomlinson


"Gord Dibben" wrote:

Most common usage is to produce an exponential value.

=2^3 returns 8

Same as =2x2x2


Gord Dibben MS Excel MVP

On Thu, 5 Oct 2006 14:14:02 -0700, timbrook

wrote:







--

Dave Peterson