When it comes to serious mathematical calculations, then most often in the expression there are many numbers squared. In specialized software, this spelling is often performed as simple as possible, as there are appropriate tools for this. However, the Excel spreadsheet editor does not have a separate button on the toolbar to square a number. Despite this, there are still ways to square in Excel.
Ways to square a number
From school math lessons, we know that a square is a number multiplied by itself, that is, the square of the number 2 will be 4, and the numbers 5 will be 25. To perform such calculations in Excel, there are two ways. The first involves the use of a special formula, where the symbol “^” is placed before the degree. The second involves a special function, which is called - "Degree". Let's look at how to square in Excel directly with examples.
Method 1: using the formula
The easiest way is to square the number using a special function. Its syntax is as follows:
= n ^ 2,
where: n is the number to be squared; ^ 2 is the degree to which a number must be raised.
Let's analyze a specific example. Suppose you need to square the number 5, to do this, follow these steps:
- Place the cursor in the cell in which you intend to do the calculations.
- Put the sign "=".
- Enter the number to be squared, in our example it is 5.
- After it write the degree - “^ 2”.
- Press Enter.
Immediately after that, the number is automatically squared. By the way, instead of indicating directly the number itself, you can specify a cell with it. In the considered example, the formula will look like this: "= C4 ^ 2"
Method 2: Using the Degree function
Excel tutorial suggests using the special "Degree" function. By the way, it’s very easy for her to use, although she implies performing a greater number of actions than in the previous method:
- Place the cursor in the cell where you plan to do the calculations.
- Click on the “Insert Function” button.
- In the Function Wizards window, select the Math category.
- From the list of functions, select Degree.
- Click OK.
A window will appear with the arguments of the selected function. As you can see, there are only two sections in it: “Number” and “Degree”. In the first column, enter the number you want to raise to the power. By the way, instead, you can specify the cell in which the number is located. In the second field, enter the number “2”, since we are faced with the task of squaring the number. After that, click "OK."
It’s so easy to square a number. Now you know at least two ways to perform this operation.