| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel displays "l" instead of "‚¬" symbol for Euro values | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| How do I enter a "Tick" symbol in Word or Excel? | Excel Discussion (Misc queries) | |||
| Why does excell switch my stock symbol "ACN" to "CAN"? | Setting up and Configuration of Excel | |||
| insert a "&" symbol in a footnote without it disappearing in excel | Excel Worksheet Functions | |||
Hybrid Mode
