Prev: excel 2007 is very slow with every entry. why the delay?
Next: hello everybody.. question about .CSV files..
From: DP on 7 May 2010 01:57
full formula below where CJ 5 is a %age. Could do with knowing what symbol is?

=($CJ$5+1)^(1/6)*CI7
--
DP
From: Jacob Skaria on 7 May 2010 02:15
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
From: FSt1 on 7 May 2010 02:35
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

"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
 | 
Pages: 1
Prev: excel 2007 is very slow with every entry. why the delay?
Next: hello everybody.. question about .CSV files..