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