What does the "^" in Excel formulas do?

B

Bob Phillips

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)
 
D

David Biddulph

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)
 

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

Top