View Single Post
  #14   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 618
Default ^ 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