what does "^" symbol mean in excel

W

willemeulen

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
 
M

Mike H

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What does "" mean in Excel? 2
Multiple IF Statements 8
Formula Fill Problems 6
How do I eliminate a symbol? 1
Symbol fonts 2
Compare 2 cells for a value 3
What does the & symbol in a formula do? 2
Why doesn't a ' symbol show up at start of Excel cell 1

Top