what is ^ in a formula for
 

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

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

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

what is ^ in a formula for
 

hi
the caret symbol(^) mean "raise to the power of"
2^3 means 2 cubed or 2 x 2 x 2 or 8

http://phoenix.phys.clemson.edu/tuto...rithmetic.html

regards
FSt1

"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