what does "^" symbol mean in excel
 

Converted a excell 2007 document back to 2003 and have cell with following
formula:

=(E9)*((1+D12)^E11)

What does '^' symbol do/mean in this formula

w

what does "^" symbol mean in excel
 

"^" = "to the power of", as in:

2^3 = 2 cubed = 2*2*2

Regards,
Fred.

"willemeulen" wrote in message
...
Converted a excell 2007 document back to 2003 and have cell with following
formula:

=(E9)*((1+D12)^E11)

What does '^' symbol do/mean in this formula

w

what does "^" symbol mean in excel
 

Hi,

The 'Caret' operator is exponation or raise to the power of so:-

=3^2

is 3 raised to the power of 2 =9


=(E9)*((1+D12)^E11)

so your formula takes 1+D12 and raises it to the power of E11 and then
multiplies that by E9.

so lest assume each of thos cells contains the number 2 we get

2*((1+2)^2)=18

Mike

takes



"willemeulen" wrote:

Converted a excell 2007 document back to 2003 and have cell with following
formula:

=(E9)*((1+D12)^E11)

What does '^' symbol do/mean in this formula

w