# SQRT Function Examples – Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on February 9, 2023

This Tutorial demonstrates how to use the Excel SQRT Function in Excel to calculate the square root.

## SQRT Function Overview

The SQRT Function Calculates the square root of a number.

To use the SQRT Excel Worksheet Function, select a cell and type:

(Notice how the formula inputs appear)

## SQRT Function Syntax and Inputs:

``=SQRT(number)``

number – A number.

## SQRT Function

The SQRT Function returns the square root of a number.

``=SQRT(81)``

The formula calculates the square root of 81. The square root of a number is a value that, when multiplied by itself, gives the number.

## SQRT Function – Negative Number

The SQRT Function returns #NUM! error when negative numbers are entered. The square root of a negative number is undefined.

``=SQRT(-81)``

## SQRT & ABS Function

You can also calculate the square root of a negative number like its positive, the ABS Function can be used.

``=SQRT(ABS(-81))``

Here, the ABS Function converts the negative number into positive number.

## SQRT Function in Google Sheets

The SQRT Function works exactly the same in Google Sheets as in Excel:

Use the SQRT Function to calculate the square root of a number.

Alternatively you can raise the number to the .5 power:

``=5^.5 is the same as =sqrt(5) is the same as =product(5,.5)``