^ Carrot in a Formula

[Ross]

I am unfamiliar with the ^ Character in a formula. What does it mean:

Example:
=+IF(T$384>0,$C416/12*(1+$C$415)^2,0)+IF(U$384=1,$C416/12*(1+$C$415)^2,0)+IF(V$384=1,$C416/12*(1+$C$415)^2,0)

Thank you

Ross

 

[Bob Phillips]

POWER

2^2=4
3^3=9

BTW the leading + in your formula is superfluous, it is a throw-back to
Lotus 1-2-3. You can even remove the IFs

=(T$384>0)*$C416/12*(1+$C$415)^2 + (U$384=1)*$C416/12*(1+$C$415)^2 +
(V$384=1)*$C416/12*(1+$C$415)^2

--
HTH

Bob Phillips

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

 

[Dave Peterson]

I think I would have used different numbers in the example <bg>:

2^3 = 2*2*2 = 8
3^4 = 3*3*3*3 = 81

 

[Ross]

This make perfect sense. Thank you Bob!

 

[Dave F]

Three to the third is 27...

Dave

 

[Bob Phillips]

It's actually 1.44225 but I take the point. <G>

-Bob

 

[Dave F]

1.44225??
--
Brevity is the soul of wit.

It's actually 1.44225 but I take the point. <G>

-Bob

 

[Duke Carey]

I think he misunderstood your "three to the third" and translated it as
"three to the one-third"

 

[Dave F]

Ahhh.

The cube root of 3.

Thanks...

 

[Don Guillett]

Caret vs carrot. Just trying to help

 

[Dave F]

Don't forget carat!

Dave

 

[Bob Phillips]

It can only be read that way, third is a fraction or a ordinal number (which
is meaningless in this context, there is no order).

--
HTH

Bob Phillips

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

 

[Dave Peterson]

Which reminds me:

Which is correct?
1. eight and eight _IS_ 17
or
2. eight and eight _ARE_ 17

The capital of Kentucky is pronounced:
1. Loo-is-vill
or
2. Loo-ee-vill

..Scroll down for answers
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
8+8=16 (not 17)
Frankfort (not Louisville)

 

[David Biddulph]

The ordinal is being used to indicate the power. Two to the fifth is the
fifth power of two (= 2^5).

 

[Gord Dibben]

Reminds me of my late daddy.

Which is correct?

the pigs is so or the pigs are so

If you gave him the correct answer he would laugh like hell.

I miss him.

Gord

Which reminds me:

Which is correct?
1. eight and eight _IS_ 17
or
2. eight and eight _ARE_ 17

The capital of Kentucky is pronounced:
1. Loo-is-vill
or
2. Loo-ee-vill

.Scroll down for answers
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
8+8=16 (not 17)
Frankfort (not Louisville)

Gord Dibben MS Excel MVP