software

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: www.excelforum.com/member.php...foamp;userid=6350
View this thread: www.excelforum.com/showthread...hreadid=536201
=POWER(A1,2)
2 is squared if you want cubed then 3, etc..--
davesexcel------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=536201How about using exponent:
=a1^2

Regards,
vcard

quot;sazizquot; gt; wrote in message
...
gt;
gt; Hi,
gt; Is there a built-in command for squaring a number in Excel?
gt; If I have a number say 5 in a cell A1 to do 5 x 5 how would I do it
gt; other than
gt; '=a1 x a1'
gt;
gt; Thanks
gt; Aziz
gt;
gt;
gt; --
gt; saziz
gt; ------------------------------------------------------------------------
gt; saziz's Profile:
gt; www.excelforum.com/member.php...foamp;userid=6350
gt; View this thread: www.excelforum.com/showthread...hreadid=536201
gt;*** Posted via a free Usenet account from www.teranews.com ***

One way

Use the exponentiation operator quot;^quot;

In say, B1: =A1^2

--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---quot;sazizquot; wrote:

gt;
gt; Hi,
gt; Is there a built-in command for squaring a number in Excel?
gt; If I have a number say 5 in a cell A1 to do 5 x 5 how would I do it
gt; other than
gt; '=a1 x a1'
gt;
gt; Thanks
gt; Aziz
gt;
gt;
gt; --
gt; saziz
gt; ------------------------------------------------------------------------
gt; saziz's Profile: www.excelforum.com/member.php...foamp;userid=6350
gt; View this thread: www.excelforum.com/showthread...hreadid=536201
gt;
gt;

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

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

Does this help?

--
Regards,
Fredquot;sazizquot; gt; wrote in message
...
gt;
gt; Hi,
gt; Is there a built-in command for squaring a number in Excel?
gt; If I have a number say 5 in a cell A1 to do 5 x 5 how would I do it
gt; other than
gt; '=a1 x a1'
gt;
gt; Thanks
gt; Aziz
gt;
gt;
gt; --
gt; saziz
gt; ------------------------------------------------------------------------
gt; saziz's Profile:
gt; www.excelforum.com/member.php...foamp;userid=6350
gt; View this thread: www.excelforum.com/showthread...hreadid=536201
gt;
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 25Gord Dibben MS Excel MVP

On Tue, 25 Apr 2006 17:53:45 -0500, saziz
gt; wrote:

gt;
gt;Hi,
gt;Is there a built-in command for squaring a number in Excel?
gt;If I have a number say 5 in a cell A1 to do 5 x 5 how would I do it
gt;other than
gt;'=a1 x a1'
gt;
gt;Thanks
gt;Aziz
Thank you all.
Aziz--
saziz
------------------------------------------------------------------------
saziz's Profile: www.excelforum.com/member.php...foamp;userid=6350
View this thread: www.excelforum.com/showthread...hreadid=536201