D DP May 7, 2010 #1 full formula below where CJ 5 is a %age. Could do with knowing what symbol is? =($CJ$5+1)^(1/6)*CI7
J Jacob Skaria May 7, 2010 #2 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)
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)
F FSt1 May 7, 2010 #3 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/tutorials/excel/arithmetic.html regards FSt1
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/tutorials/excel/arithmetic.html regards FSt1
