Excel SQRT Function

The Excel SQRT function returns the square root of a number.

The SQRT function is a built-in function in Excel that is categorized as a Math/Trig Function. It can be used as a worksheet function in Excel. As a worksheet function, the SQRT function can be used as part of a formula in a worksheet cell.

Syntax

SQRT(number)

Parameters

Return Value

Returns the square root of a value.

Notes

• If the argument is a negative number, SQRT returns #NUM! error.
• If the argument is a non-numeric value, SQRT returns #VALUE! error.

Example: Using as Worksheet Function

The example below shows how to use the SQRT function as worksheet function.

Based on the Excel spreadsheet above, the output of the following worksheet formula will be:

=SQRT(B5)
Result: 0

=SQRT(B6)
Result: 1

=SQRT(B7)
Result: 2

=SQRT(B8)
Result: 3.16227766

=SQRT(B9)
Result: 5

=SQRT(B10)
Result: 7.071067812

=SQRT(B11)
Result: 8.660254038