Use of ^ symbol in a formula
 

I am looking at a spread sheet with the following formula : H17*(1+AJ17)^4.
Can anyone tell me what the ^ function means? I have never seen it used this
way before.

Use of ^ symbol in a formula
 

You are raising (1+AJ17) to the fourth power. It is little seen outside of
thermodynamics or physical chemistry.
--
Gary's Student


"kd" wrote:

I am looking at a spread sheet with the following formula : H17*(1+AJ17)^4.
Can anyone tell me what the ^ function means? I have never seen it used this
way before.

Use of ^ symbol in a formula
 

^ means: to the power of

So:

H17*(1+AJ17)^4 =

H17 * (1+AJ17 to the 4th power)

Assume AJ17 = 1

1+1^4 =

2*2*2*2 = 16 =

H17 * 16

Biff

"kd" wrote in message
...
I am looking at a spread sheet with the following formula : H17*(1+AJ17)^4.
Can anyone tell me what the ^ function means? I have never seen it used
this
way before.

Use of ^ symbol in a formula
 

Gary''s Student wrote...
You are raising (1+AJ17) to the fourth power. It is little seen outside of
thermodynamics or physical chemistry.

Given an effective periodic interest rate i, if you deposit an amount P
at time 0, at time 4 the accumulated value will be P*(1+i)^4.

Little seen outside of thermodynamics or physical chemistry?! Perhaps
so for those who don't know anything about finance.

Use of ^ symbol in a formula
 

Ouch.
--
Brevity is the soul of wit.


"Harlan Grove" wrote:

Gary''s Student wrote...
You are raising (1+AJ17) to the fourth power. It is little seen outside of
thermodynamics or physical chemistry.

Given an effective periodic interest rate i, if you deposit an amount P
at time 0, at time 4 the accumulated value will be P*(1+i)^4.

Little seen outside of thermodynamics or physical chemistry?! Perhaps
so for those who don't know anything about finance.

Use of ^ symbol in a formula
 

Knowledge of finance ?!?! I can't even balance a checkbook!!

(that's why I am learning Excel)
--
Gary's Student


"Harlan Grove" wrote:

Gary''s Student wrote...
You are raising (1+AJ17) to the fourth power. It is little seen outside of
thermodynamics or physical chemistry.

Given an effective periodic interest rate i, if you deposit an amount P
at time 0, at time 4 the accumulated value will be P*(1+i)^4.

Little seen outside of thermodynamics or physical chemistry?! Perhaps
so for those who don't know anything about finance.

Use of ^ symbol in a formula
 

I can balance my checkbook and I have a background in chemistry!

Biff

"Dave F" wrote in message
...
Ouch.
--
Brevity is the soul of wit.


"Harlan Grove" wrote:

Gary''s Student wrote...
You are raising (1+AJ17) to the fourth power. It is little seen outside
of
thermodynamics or physical chemistry.

Given an effective periodic interest rate i, if you deposit an amount P
at time 0, at time 4 the accumulated value will be P*(1+i)^4.

Little seen outside of thermodynamics or physical chemistry?! Perhaps
so for those who don't know anything about finance.

Use of ^ symbol in a formula
 

Can anyone tell me what the ^ function means?

Excel's help entitled "About calculation operators"
calls the "caret" symbol "Exponentiation"
Shorthand for the Power Function.
=POWER(5,2), or 5^2
--
HTH :)
Dana DeLouis
Windows XP & Office 2003


"kd" wrote in message
...
I am looking at a spread sheet with the following formula : H17*(1+AJ17)^4.
Can anyone tell me what the ^ function means? I have never seen it used
this
way before.

Use of ^ symbol in a formula
 

I think that's called bookkeeping. <g

"T. Valko" wrote:

I can balance my checkbook and I have a background in chemistry!

Biff

"Dave F" wrote in message
...
Ouch.
--
Brevity is the soul of wit.


"Harlan Grove" wrote:

Gary''s Student wrote...
You are raising (1+AJ17) to the fourth power. It is little seen outside
of
thermodynamics or physical chemistry.

Given an effective periodic interest rate i, if you deposit an amount P
at time 0, at time 4 the accumulated value will be P*(1+i)^4.

Little seen outside of thermodynamics or physical chemistry?! Perhaps
so for those who don't know anything about finance.