| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What does a ^ symbol mean used in a formula
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 ... |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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: |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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: |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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: |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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: |
|
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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: |
|
#14
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#15
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find value in array | Excel Worksheet Functions | |||
| Is it possible? | Excel Worksheet Functions | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| What does the "$" symbol do to a cell value in a formula. | Excel Discussion (Misc queries) | |||
| What does the "$" symbol do to a cell value in a formula. | Excel Discussion (Misc queries) | |||
Linear Mode
