| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Square a value
Can anyone show me how to write a formula to square a value in another cell?
-- Barry Guidry |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Square a value
=POWER(A1,2)
=A1*A1 =A1^2 HTH "Barry" wrote: Can anyone show me how to write a formula to square a value in another cell? -- Barry Guidry |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Square a value
=A1^2
=2^2 etc. The ^ symbol indicates exponentiation. If you're raising to a fractional power (or taking a root other than the square root, parentheses are important; i.e., =A1^(1/3) etc. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Barry" wrote: Can anyone show me how to write a formula to square a value in another cell? -- Barry Guidry |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Square a value
=power(A16,2)
-- Greetings from New Zealand "Barry" wrote in message ... Can anyone show me how to write a formula to square a value in another cell? -- Barry Guidry |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Square a value
Sorry, but I found it by clicking on the drop-down list of functions to the
left of the fx enter window and searching for "square a value", which returned the 'POWER' function, which is =POWER(Number, Power) -- Barry Guidry "Barry" wrote: Can anyone show me how to write a formula to square a value in another cell? -- Barry Guidry |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trendline R square | Charts and Charting in Excel | |||
| How do I type x square? | Excel Discussion (Misc queries) | |||
| square cells | Setting up and Configuration of Excel | |||
| how to center a square plot area in a square chart | Charts and Charting in Excel | |||
| Regression Output -- R Square versus Adjusted R Square | Excel Discussion (Misc queries) | |||
Linear Mode
