How to Square Numbers – Excel & Google Sheets

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.


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

AI Formula Generator

Try for Free

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