squaring a number

S

saziz

Hi,
Is there a built-in command for squaring a number in Excel?
If I have a number say 5 in a cell A1 to do 5 x 5 how would I do it
other than
'=a1 x a1'

Thanks
Aziz
 
V

vcard

How about using exponent:
=a1^2

Regards,
vcard

saziz said:
Hi,
Is there a built-in command for squaring a number in Excel?
If I have a number say 5 in a cell A1 to do 5 x 5 how would I do it
other than
'=a1 x a1'

Thanks
Aziz
Click to expand...


*** ***
 
F

Fred Smith

There is a power function in Excel, and an exponentiation operator. So your
choices are:

=a1*a1
=a1^2
=Power(a1,2)

Does this help?
 
G

Gord Dibben

Using the caret(^) found on the keyboard you construct a formula...............

=5^2 returns 25 which is 5 squared

=5^3 returns 125 which is 5 cubed

Or you can use the more unwieldy POWER function.

=POWER(5,2) to return 25


Gord Dibben MS Excel MVP
 
Top