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
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
=POWER(A1,2)
2 is squared if you want cubed then 3, etc..
How about using exponent:
=a1^2
Regards,
vcard
"saziz" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>
>
> --
> saziz
> ------------------------------------------------------------------------
> saziz's Profile:
> http://www.excelforum.com/member.php...fo&userid=6350
> View this thread: http://www.excelforum.com/showthread...hreadid=536201
>
*** Posted via a free Usenet account from http://www.teranews.com ***
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?
--
Regards,
Fred
"saziz" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>
>
> --
> saziz
> ------------------------------------------------------------------------
> saziz's Profile:
> http://www.excelforum.com/member.php...fo&userid=6350
> View this thread: http://www.excelforum.com/showthread...hreadid=536201
>
One way
Use the exponentiation operator "^"
In say, B1: =A1^2
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"saziz" wrote:
>
> 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
>
>
> --
> saziz
> ------------------------------------------------------------------------
> saziz's Profile: http://www.excelforum.com/member.php...fo&userid=6350
> View this thread: http://www.excelforum.com/showthread...hreadid=536201
>
>
Thank you all.
Aziz
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
On Tue, 25 Apr 2006 17:53:45 -0500, saziz
<[email protected]> wrote:
>
>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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks