How to Make a Square Excel Calculation and All Its Formulas & Functions - Compute Expert

How to Make a Square Excel Calculation and All Its Formulas & Functions


Home >> Excel Tutorials from Compute Expert >> Excel Calculations >> How to Make a Square Excel Calculation and All Its Formulas & Functions





In this tutorial, we will discuss completely how to make a square excel calculation on a number. All formulas/functions we can use to calculate square in excel will also be explained here.

One calculation we often do when processing numbers is square/the power of two. If we often use excel as a tool to process our numbers, then understanding the way to square there becomes important.

Generally, the method to write a square formula in excel can be divided into three. They are the manual writing with the ^ symbol, manual writing with the * symbol, and the POWER formula. We will talk in the next parts about the general writing form for each, example, and their writing steps in detail.

Disclaimer: This post may contain affiliate links from which we earn commission from qualifying purchases/actions at no additional cost for you. Learn more

Want to work faster and easier in Excel? Install and use Excel add-ins! Read this article to know the best Excel add-ins to use according to us!

Learn Excel Dashboard Course






How to Write a Square Excel Calculation With the ^ Symbol

Now, we will discuss the first method to do a square excel calculation, which is by using the ^ symbol.

The caret symbol (^) is a power calculation symbol in excel formula writing. Because the square is the same as the power of 2, we can use it to get a square calculation result.

Generally, here is the writing to calculate a square in excel with the ^ symbol.

=number ^ 2


The number there is the number you want to square/power by 2 in excel. The number input in the formula can be typed or inputted through the media of a cell coordinate.

We use ^ in the writing as a power symbol and 2 as the power factor. We use 2 there because what we look for is the square or the power of 2 from our number.

Write that writing form correctly in your cell and enter. You will immediately get the square result of your number!

To make it clearer about the writing, see its implementation example in excel below.

How to Make a Square Excel Calculation and All Its Formulas & Functions - Screenshot of the Example of Using the ^ Symbol to Square a Number in Excel

You can see the writing example in the screenshot’s formula bar. We get the square of all the numbers on the left using that form of writing.

To make you understand further about this method to write a square formula, we will give the detailed writing steps here. We will explain each step with the help of a screenshot to make you understand it easier.



  1. Type an equal sign ( = ) in the cell where you want to put the square result of your number

    How to Make a Square Excel Calculation and All Its Formulas & Functions - Screenshot of Step 1-1

  2. Input the number to be squared or the cell coordinate where it is after =. Type a caret symbol ( ^ ) after that

    How to Make a Square Excel Calculation and All Its Formulas & Functions - Screenshot of Step 1-2

  3. Type 2

    How to Make a Square Excel Calculation and All Its Formulas & Functions - Screenshot of Step 1-3

  4. Press Enter
  5. The process is done!

    How to Make a Square Excel Calculation and All Its Formulas & Functions - Screenshot of Step 1-5




How to Write a Square Excel Calculation With the * Symbol

There is another method for us to write a square calculation formula in excel. That method is using the help of the * symbol.

As we know, the power calculation is the same as multiplying a number with the number itself. Because of that, we can multiply our number with its own value to get its square result in excel.

The symbol that represents multiplication in excel is the star symbol or *. Therefore, we can square our number by using the * symbol in the writing that we do.

Generally, here is the writing form of a square formula in excel with the * symbol.

=number * number


The number there is the number we want to square in our data processing.

To make it clearer about this square formula writing with the * symbol, here is its implementation example in excel.

How to Make a Square Excel Calculation and All Its Formulas & Functions - Screenshot of the Example of Using the * Symbol to Square a Number in Excel

As we can see in the screenshot’s formula bar, the writing in the example uses the form explained earlier. Write the multiplication formula correctly and you can get the square result of your number easily!

To add your understanding about this method’s application, here is the step-by-step of its writing in detail.

  1. Type an equal sign ( = ) in the cell where you want to put the square result of your number

    How to Make a Square Excel Calculation and All Its Formulas & Functions - Screenshot of Step 2-1

  2. Input the number to be squared or the cell coordinate where it is after =. Type a star symbol ( * ) after that

    How to Make a Square Excel Calculation and All Its Formulas & Functions - Screenshot of Step 2-2

  3. Input the number or the cell coordinate again

    How to Make a Square Excel Calculation and All Its Formulas & Functions - Screenshot of Step 2-3

  4. Press Enter
  5. The process is done!

    How to Make a Square Excel Calculation and All Its Formulas & Functions - Screenshot of Step 2-5




How to Make a Square Excel Calculation With the POWER Formula

What if we want to use a built-in formula available in excel to square our number? This can be done by using the POWER formula.



POWER is made by excel to calculate the power of a number in our worksheet. The inputs it needs are the number we want to power and the power factor. By inputting 2 in its power factor input, we can get the square result of our number using this formula.

Generally, here is the writing form of POWER so we can get our square calculation result from it.

=POWER(number, 2)


Don’t forget to input 2 in the power factor input part so you can get the correct result.

The implementation example of the writing in excel is as follows.

How to Make a Square Excel Calculation and All Its Formulas & Functions - Screenshot of the Example of Using the POWER Formula to Square a Number in Excel

As you can see, POWER can be used to do your number’s square calculation. Give your inputs correctly and you can get your result fast!

To add to your understanding of this method, here are the writing steps.

  1. Type an equal sign ( = ) in the cell where you want to put the result in

    How to Make a Square Excel Calculation and All Its Formulas & Functions - Screenshot of Step 3-1

  2. Type POWER (can be with large and small letters) and an open bracket sign after =

    How to Make a Square Excel Calculation and All Its Formulas & Functions - Screenshot of Step 3-2

  3. Input the number to be squared or the cell coordinate where it is after the open bracket sign. Then type a comma sign ( , )

    How to Make a Square Excel Calculation and All Its Formulas & Functions - Screenshot of Step 3-3

  4. Type 2

    How to Make a Square Excel Calculation and All Its Formulas & Functions - Screenshot of Step 3-4

  5. Type a close bracket sign

    How to Make a Square Excel Calculation and All Its Formulas & Functions - Screenshot of Step 3-5

  6. Press Enter
  7. The process is done!

    How to Make a Square Excel Calculation and All Its Formulas & Functions - Screenshot of Step 3-7




Exercise

After learning the methods to write a square formula in excel, now let’s do an exercise. This is so you can deepen your understanding of those methods.

Download the following exercise file and answer all the questions. Download the answer key file if you have finished the exercise and want to check your answers. Or probably when you are confused about how to answer the questions.

Link to the exercise file:
Download here

Questions

  1. What is the final score of each person? Use the ^ symbol method to find the answer!
  2. What is the final score of each person? Use the * symbol method to find the answer!
  3. What is the final score of each person? Use the POWER formula method to find the answer!

Link to the answer key file:
Download here



Additional Note

To do the power calculation with other factors besides 2, you can learn it by visiting this Compute Expert tutorial.



Related tutorials you should learn:



Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!





Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!




Learn Excel Dashboard Course

Follow our tutorial content also on


Excel Calculation

Sum in Excel

Subtraction in Excel

Multiplication in Excel

Division in Excel

Average in Excel



Excel Formula

VLOOKUP Function in Excel

IF Function in Excel

SUM Function in Excel

COUNTIFS Function in Excel

SUMIFS Function in Excel



Excel Tips and Trick

How to Print in Excel

Convert Number to Text in Excel

Excel Worksheet Definition

Excel Range Definition

Excel Shortcuts



Excel Products & Services Recommendation

Best Laptops for Excel

Best Tablets for Excel

Best Keyboards for Excel

Best Mouse for Excel

Best Monitors for Excel



Excel Consultation

Recommended Things

About Us

Contact Us

Privacy Policy

Affiliate Disclosure

Terms & Condition



© 2024 Compute Expert