SQRT Function in Excel – Find Square Root Easily

Do you want to find the square root of a number in Excel?

The SQRT function helps you do it in just one simple formula.

It’s very useful in daily calculations, reports, or math-related tasks where you need quick results.

What Is the SQRT Function?

In everyday math, a square root is a number that, when multiplied by itself, gives the original number.

For example:

√16 = 4, because 4 × 4 = 16.

In Excel, you can quickly find square roots using the SQRT function.

SQRT stands for Square Root.

It helps you find the square root of any positive number you enter.

Syntax:

=SQRT(number)

number → The value you want the square root of.

Examples:

NumberFormulaResult
4=SQRT(4)2
9=SQRT(A3)3
16=SQRT(A4)4
25=SQRT(A5)5
100=SQRT(A6)10

Tip: Use a cell reference like `=SQRT(A3)` so you can change the number anytime and get instant results.

SQRT Function in Excel

If You Get an Error:

 If you try to find the square root of a negative number, Excel will show a `NUM!` error.

To fix it, use the ABS function to make it positive:

=SQRT(ABS(A1))

This formula removes the negative sign and gives the correct result.

ABS function to make number positive in excel

Alternative Methods to Find Square Root:

FormulaMeaningResult
=SQRT(16)Square root of 164
=POWER(16, 0.5)16 to the power of ½4
=16^0.5Using caret symbol4

All give the same result.

  • Use `SQRT` when you only need the square root.
  • Use `POWER` or `^` when you are working with other powers or mixed formulas.

The SQRT function is simple but powerful. It helps you find square roots instantly.

Once you try it, you’ll see how easily Excel can handle even maths problems.


Discover more from Excellopedia

Subscribe to get the latest posts sent to your email.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.