View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default what is ^ in a formula for

The "^" operator can be used instead of POWER() to indicate to what power the
base number is to be raised, such as in 5^2. This returns the result of a
number raised to a power

=POWER(5,2)

--
Jacob (MVP - Excel)


"DP" wrote:

full formula below where CJ 5 is a %age. Could do with knowing what symbol is?

=($CJ$5+1)^(1/6)*CI7
--
DP