Basic mathematic operations include addition, subtraction, multiplication, and division. These operations can be performed on both whole numbers and fractions. In addition, there are more complex operations that can be performed on numbers, such as squares and power. Excel has an in-built function Power to square a number.
This blog will show you how to square a number in Excel. You will learn how to use the POWER function, CARET ^ operator and the Multiply * Operator function.
Square a Number – multiply the value by itself
In this method, you use the multiplication * operator to multiply the value by itself to square a number.
Suppose you have a number in cell A1 and need to square the A1 value and display it in cell B1.
Go to cell B1, Type the formula =A1*A1, and then Press Enter
Square a Number using the caret (^) operator
The Caret ^ operator in Excel raises a number to a power. You can use Caret ^ operator to square a number in excel.
For example, 2^3 = 8. You can use the caret operator to calculate exponents in Excel.
Please follow the below steps to use CARET ^ operator in excel to square a number.
Go to cell B1, Type the formula =A1^2, and then Press Enter
You can see the squared value in cell B1
Square a Number with the POWER function
This section explains to you step by step how to use the POWER Function in Excel and square a number.
This function takes two arguments, the number to be squared and the exponent, which is 2 in this case.
Syntax: Power ( number, power )
- Go to cell B1
- Type the formula =Power (A1,2)
- and then Press Enter
The result of this function is 25. if the value 5 in the worksheet Cell A1.
Conclusions
You learned three different ways to square a number in excel. The most simple way is to just use the operators either Multiplication * or Caret ^.
If you have any questions, please leave a comment below and I will get back to you as soon as possible.
