What does ^ operator mean in a formula??

V

Vytau

There are a number of formulas that have ^ in them. What does the ^ operator
mean?? i.e. $Z$4^2
 
D

David Biddulph

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

the ^ (caret symbol) is used for exponentiation... in your example the value
in cell Z4 is being squared.
 

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

Double Equals Operator? 5
=SUMPRODUCT(--(TRIM(A1:A10)<>"")), what does the "--" mean? 1
Unary + Operator 5
Double unique formula 5
EXACT function vs. equals operator 11
Reference an Operator from a cell with Sumproduct 4
Change operator from cell value 5
Scrabble Value calculation for Welsh words 0

Top