View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default ^ Carrot in a Formula

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