^ Carrot in a Formula
 

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

Example:
=+IF(T$3840,$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

^ Carrot in a Formula
 

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$3840)*$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)

"Ross" wrote in message
...

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

Example:

=+IF(T$3840,$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

^ Carrot in a Formula
 

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



Bob Phillips wrote:

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$3840)*$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)

"Ross" wrote in message
...

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

Example:

=+IF(T$3840,$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




--

Dave Peterson

^ Carrot in a Formula
 

This make perfect sense. Thank you Bob!


"Ross" wrote:


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

Example:
=+IF(T$3840,$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

^ Carrot in a Formula
 

Three to the third is 27...

Dave
--
Brevity is the soul of wit.


"Bob Phillips" wrote:

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$3840)*$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)

"Ross" wrote in message
...

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

Example:

=+IF(T$3840,$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

^ Carrot in a Formula
 

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

-Bob


"Dave F" wrote in message
...
Three to the third is 27...

Dave
--
Brevity is the soul of wit.


"Bob Phillips" wrote:

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$3840)*$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)

"Ross" wrote in message
...

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

Example:


=+IF(T$3840,$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

^ Carrot in a Formula
 

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


"Bob Phillips" wrote:

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

-Bob


"Dave F" wrote in message
...
Three to the third is 27...

Dave
--
Brevity is the soul of wit.


"Bob Phillips" wrote:

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$3840)*$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)

"Ross" wrote in message
...

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

Example:


=+IF(T$3840,$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

^ Carrot in a Formula
 

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

"Dave F" wrote:

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


"Bob Phillips" wrote:

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

-Bob


"Dave F" wrote in message
...
Three to the third is 27...

Dave
--
Brevity is the soul of wit.


"Bob Phillips" wrote:

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$3840)*$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)

"Ross" wrote in message
...

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

Example:


=+IF(T$3840,$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

^ Carrot in a Formula
 

Ahhh.

The cube root of 3.

Thanks...
--
Brevity is the soul of wit.


"Duke Carey" wrote:

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

"Dave F" wrote:

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


"Bob Phillips" wrote:

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

-Bob


"Dave F" wrote in message
...
Three to the third is 27...

Dave
--
Brevity is the soul of wit.


"Bob Phillips" wrote:

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$3840)*$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)

"Ross" wrote in message
...

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

Example:


=+IF(T$3840,$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

^ Carrot in a Formula
 

Caret vs carrot. Just trying to help

--
Don Guillett
SalesAid Software

"Ross" wrote in message
...

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

Example:
=+IF(T$3840,$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

^ Carrot in a Formula
 

Don't forget carat!

Dave
--
Brevity is the soul of wit.


"Don Guillett" wrote:

Caret vs carrot. Just trying to help

--
Don Guillett
SalesAid Software

"Ross" wrote in message
...

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

Example:
=+IF(T$3840,$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

^ Carrot in a Formula
 

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)

"Duke Carey" wrote in message
...
I think he misunderstood your "three to the third" and translated it as
"three to the one-third"

"Dave F" wrote:

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


"Bob Phillips" wrote:

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

-Bob


"Dave F" wrote in message
...
Three to the third is 27...

Dave
--
Brevity is the soul of wit.


"Bob Phillips" wrote:

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$3840)*$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)

"Ross" wrote in message
...

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

Example:



=+IF(T$3840,$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

^ Carrot in a Formula
 

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)





Dave F wrote:

Three to the third is 27...

Dave
--
Brevity is the soul of wit.

"Bob Phillips" wrote:

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$3840)*$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)

"Ross" wrote in message
...

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

Example:

=+IF(T$3840,$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







--

Dave Peterson

^ Carrot in a Formula
 

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

"Bob Phillips" wrote in message
...
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)

"Duke Carey" wrote in message
...
I think he misunderstood your "three to the third" and translated it as
"three to the one-third"

"Dave F" wrote:

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


"Bob Phillips" wrote:

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

-Bob


"Dave F" wrote in message
...
Three to the third is 27...

Dave
--
Brevity is the soul of wit.


"Bob Phillips" wrote:

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$3840)*$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)

"Ross" wrote in message
...

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

Example:



=+IF(T$3840,$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

^ Carrot in a Formula
 

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

On Thu, 09 Nov 2006 12:06:54 -0600, Dave Peterson
wrote:

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)





Dave F wrote:

Three to the third is 27...

Dave
--
Brevity is the soul of wit.

"Bob Phillips" wrote:

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$3840)*$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)

"Ross" wrote in message
...

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

Example:

=+IF(T$3840,$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







Gord Dibben MS Excel MVP