Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
squaring a number
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
squaring a number
=POWER(A1,2) 2 is squared if you want cubed then 3, etc.. -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=536201 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
squaring a number
How about using exponent:
=a1^2 Regards, vcard "saziz" wrote in message ... 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 *** |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
squaring a number
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
squaring a number
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, Fred "saziz" wrote in message ... 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
squaring a number
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 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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
squaring a number
Thank you all. Aziz -- saziz ------------------------------------------------------------------------ saziz's Profile: http://www.excelforum.com/member.php...fo&userid=6350 View this thread: http://www.excelforum.com/showthread...hreadid=536201 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excell-How to add the number of cells containing text? = a sum | Excel Worksheet Functions | |||
Generating (in a random order)each number once from a given number | Excel Worksheet Functions | |||
Change number format from text to number? | New Users to Excel | |||
vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
Count Number of Characters in a cell? | Excel Discussion (Misc queries) |