| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What does ^ operator mean in a formula??
There are a number of formulas that have ^ in them. What does the ^ operator
mean?? i.e. $Z$4^2 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What does ^ operator mean in a formula??
Raise to a power.
=$Z$4^2 is the same as =POWER($Z$4,2) or =$Z$4*$Z$4^2 or $Z$4 squared =2^4 is the same as =2*2*2*2 -- David Biddulph "Vytau" wrote in message ... There are a number of formulas that have ^ in them. What does the ^ operator mean?? i.e. $Z$4^2 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What does ^ operator mean in a formula??
the ^ (caret symbol) is used for exponentiation... in your example the value
in cell Z4 is being squared. "Vytau" wrote: There are a number of formulas that have ^ in them. What does the ^ operator mean?? i.e. $Z$4^2 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to add commas to the result of a formula with a text operator? | Excel Discussion (Misc queries) | |||
| Logical operator in Calculated Field Formula | Excel Discussion (Misc queries) | |||
| Array Formula with AND operator | Excel Worksheet Functions | |||
| What does ! mean as an operator within a formula | Excel Discussion (Misc queries) | |||
| "--" operator in a formula | Excel Worksheet Functions | |||
Linear Mode
