SQRT Function Examples – Excel & Google Sheets

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

SQRT Main Function

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:

sqrt formula syntax

(Notice how the formula inputs appear)

SQRT Function Syntax and Inputs:

number – A number.

AutoMacro - VBA Code Generator

SQRT Function 

The SQRT Function returns the square root of a number. 

SQRT 01

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 02

SQRT & ABS Function 

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

SQRT 03

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:

SQRT Google Function

Additional Notes

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)

Return to the List of all Functions in Excel

 

Excel Practice Worksheet

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

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!