There are multiple ways to calculate the square of a number in Excel.
You can use the in-built POWER function or the Caret operator (^).
Let me show you how to quickly calculate the square of a number in Excel.
Using the POWER Function
POWER function allows you to get the square, cube, or any power of a number with a simple formula.
Below I have a dataset and I want to get the square value of the numbers in column A in column B.
Here is the formula that will give us the square of the numbers:
=POWER(A2,2)
I entered this formula and cell B2 and then copied it for all the other cells in the column.
In the above formula, the first argument is the cell reference that has the number, and the second argument is the exponent that should be raised to this number.
You can also use this formula to calculate the cube value, quartic value, or any other polynomial value for a number.
For example, if you want to calculate the cube of a number, you can use =POWER(A2,3).
Also read: How to Calculate Square Root in Excel
Using the ^ (Caret) Operator
Another quick way to get the square of a number is by using the Caret Operator (^).
Below, I have a data set where I have numbers in column A, and I want to calculate the square of these numbers and get the result in column B.
Here is the formula to do that using the caret operator:
=A2^2
I entered this formula in cell B2 and then copied it for all the other cells.
In case you want to calculate the cube of a number, you can use A2^3.
Note: To get the Caret operator in the formula, hold the Shift key and then press the number 6 key on your keyboard
Also read: Calculate Percentage Change in Excel (% Increase/Decrease)
Using a Simple Multiplication
And finally, you can also use simple multiplication, where you multiply the number by itself to get its square value.
Below is the data set where I have numbers in column A, and I want to get the square values in column B.
Here is the formula to do this:
=A2*A2
So, these are three simple methods you can use to quickly calculate the square of a number in Excel.
All the methods covered in this article can also be used in Google Sheets.
I hope you found this article helpful.
Other Excel articles you may also like:
