How To Square Numbers - Excel & Google Sheets

Return to Excel Formulas List

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on February 8, 2023 Download Example Workbook

Download the example workbook

This tutorial will illustrate how to square a number in Excel & Google Sheets.

square numbers Main Function

Square a Number using Caret Operator (^)

To square a number, you can either use the Caret/Exponent Operator (^) or the POWER function.

In this example, we use the Caret Operator.

=B3^(2)

Caret Operator

Square a Number using POWER Function

The POWER function returns the result for a given number raised to a power. Its syntax is:

=POWER(B3,2)

POWER Function

Negative numbers can be squared in a similar manner using both the functions.

Note: To take the square root of a number, simply use 1/2 instead of 2.

Try our AI Formula Generator

Generate

Square Numbers in Google Sheets

These formulas work exactly the same in Google Sheets as in Excel

square numbers Google Function

AI Formula Generator

Try for Free

AI Tools

  • Excel Help Bot
  • Formula Generator
  • Formula Explainer
  • VBA Code Generator
  • VBA Code Commenter
  • Excel Template Generator

Excel Practice Worksheet

practice excel worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!

Free Download

Return to Excel Formulas List

← Reverse the Order of a List / Range – Excel & Google SheetsHow to Calculate Square Roots – Excel & Google Sheets →

Try our AI Formula Generator

Generate =SUMIF(A:A, "Q1", B:B)

Tag » How To Square A Number In Excel