How to Square a Number in Excel

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.

Dataset to Square values in Excel

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.

POWER formula to Square number in Excel

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.

Dataset to Square values in Excel

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.

CARET Operator to Square number in Excel

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.

Dataset to Square values in Excel

Here is the formula to do this:

=A2*A2
Multiplication to Square number in Excel

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:

Excel Ebook Subscribe

FREE EXCEL BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Sumit Bansal
Hello there! I'm Sumit Bansal, founder of trumpexcel.com and an Excel MVP. I started this website in 2013 with a simple goal: to share my love for Excel through easy to follow tips, tutorials and videos. I'm here to help you get the best out of MS Excel to save time and boost your productivity.

Leave a Comment