View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default ^ 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