Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|