^ 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
|