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

Need help removing extra TOC text from number lists used as TOC levels 0
Payment calculation 1
Excel - Wich Function should I use? 1
What does -- symbol mean in an excel formulae eg: SUMPRODUCT(--(A1:A10="Luke 2
Copy addition formula of non-consecutive horizontal cells 2
Document Merge Formatting Issue 0
How do I eliminate a symbol? 1
Matching literal text "???" in Word 2010 field code IF statement 2

Top