View Single Post
  #15   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default ^ 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