| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What does the "^" in Excel formulas do?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What does the "^" in Excel formulas do?
It is 'to the Power of'
2^2 = 4 3^2 = 9 3^3 = 27 etc. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Rhenier" wrote in message ... |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What does the "^" in Excel formulas do?
Please ask your question in the body of the text, not just in the subject
line. Blank messages will often be rejected by newsreading software or ignored by contributors to the group. The ^ symbol raises a number to a power. =2^3 is =2*2*2 =8 =A1^B1 is equiivalent to =POWER(A1,B1) -- David Biddulph "Rhenier" wrote in message ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help!!! Enter "7" in a cell and Excel changes the "7" to "11" immediately!!! | Excel Discussion (Misc queries) | |||
| Combine logical formulas "if", "and", "or" | Excel Discussion (Misc queries) | |||
| Combining formulas, "and" & "or" to verify content of multiple cel | Excel Discussion (Misc queries) | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Hybrid Mode
