SQRT Function in Excel: Square Root

⏱ 1 min readUpdated 28 September 2026

MathLevel: BeginnerAvailable in: Excel 2007+

In this article
  1. Syntax
  2. Examples
  3. Example 1
  4. Example 2
  5. Common errors and fixes
  6. Related functions

SQRT returns the positive square root.

Syntax

=SQRT(number)
Argument What it means
number Zero or positive.

Examples

Example 1

=SQRT(A2^2+B2^2)

Straight-line distance from x/y differences.

Example 2

=STDEV.S(B2:B253)*SQRT(252)

Annualise daily volatility (252 trading days).

Common errors and fixes

You see Why, and the fix
#NUM! Negative number. Use ABS if appropriate.

POWER · ABS

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.

Keep reading

Excel Functions A–ZHARMEAN Function in Excel: The Right Average for RatesExcel Functions A–ZVLOOKUP Function in Excel: Look Up a Value in the First Column of a TableExcel Functions A–ZVSTACK Function in Excel: Stack Tables Vertically
✨ Ask AI about this article

Stuck on a step? Ask a question and the AI answers using this article.

Free · AI can be wrong