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