What does the symbol ^ mean in Excel formulas?

Desert Rat · 02-11-2006, 08:10 AM

I am having trouble finding out the purpose of the symbol ^ when using
calculations in Excel. Can anyone help me?

flummi · 02-11-2006, 08:15 AM

3^3 = 27 which means 3 raised to the power of 3

Hans

Max · 02-11-2006, 08:20 AM

Caret: "^" means "to the power of"

Eg: entering in say, A1: =3^4
means to evaluate 3 to the power of 4
i.e: =3x3x3x3=81

Likewise =2^3 = 2x2x2=8
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Desert Rat" <Desert [email protected]> wrote in message
news:[email protected]...
> I am having trouble finding out the purpose of the symbol ^ when using
> calculations in Excel. Can anyone help me?

bigwheel · 02-11-2006, 08:20 AM

It means "raise to the power of" so that 2^3 means 2 raised to the power of 3
(or 2 cubed) which equals 8

"Desert Rat" wrote:

> I am having trouble finding out the purpose of the symbol ^ when using
> calculations in Excel. Can anyone help me?

[email protected] · 02-11-2006, 03:10 PM

"Desert Rat" wrote:
> I am having trouble finding out the purpose of the
> symbol ^ when using calculations in Excel. Can
> anyone help me?

For future reference, use the key phrase "calculation operators"
in a Help search, and see the Help page "about calculation
operators".

Bernard Liengme · 02-11-2006, 03:10 PM

You got lots of good answers but if you need another:
The one-word name for the ^ operator is "exponentiation"
just as + is addition, × is multiplication.....
For confirmation of this lovely geek work, see
http://en.wikipedia.org/wiki/Exponentiation
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Desert Rat" <Desert [email protected]> wrote in message
news:[email protected]...
>I am having trouble finding out the purpose of the symbol ^ when using
> calculations in Excel. Can anyone help me?

**lskidmore4285** · 03-25-2013, 02:56 PM

I'm trying to total hours on my schedule worksheet. For example A1 is the "time in" and B1 is the time out. The cells are formatted for time hh:mm but I don't know the formula to total those hours at the end of the week. Any ideas?

**HaHoBe** · 03-25-2013, 03:04 PM

Hi, lskidmore4285,

welcome to the Forum.

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

Ciao,
Holger