V Vytau Nov 30, 2007 #1 There are a number of formulas that have ^ in them. What does the ^ operator mean?? i.e. $Z$4^2
D David Biddulph Nov 30, 2007 #2 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
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
B BoniM Nov 30, 2007 #3 the ^ (caret symbol) is used for exponentiation... in your example the value in cell Z4 is being squared.
the ^ (caret symbol) is used for exponentiation... in your example the value in cell Z4 is being squared.
