Return to Excel Formulas List

How to Square Numbers – Excel & Google Sheets

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.

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 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.

Square Numbers in Google Sheets

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

square numbers Google Function