How to use the Excel SQRT function

Summary

The Excel SQRT function returns the square root of a positive number. SQRT returns an error if number is negative.

Purpose

Find the positive square root of a number

Return value

Positive square root

Syntax

=SQRT (number)

Arguments

number - The number to get the square root of.

Version

Excel 2003

Usage notes

The SQRT function will return a #NUM error when asked to take the square root of a negative number. If you need to get the square root of a negative value (as if the value was positive) you can wrap the number in the ABS function like this:

=SQRT(ABS(A1))

Related functions

Excel POWER Function

The Excel POWER function returns a number to a given power. The POWER function works like an exponent in a standard math equation.

500 Formulas | 101 Functions

Exceljet

Quick, clean, and to the point

Excel SQRT Function

Download 200+ Excel Shortcuts

Excel video training

Excel SQRT Function

SQRT formula examples

Download 200+ Excel Shortcuts

Excel video training