Start Free Course

Square Root In Excel (SQRT)

Written by ExcelMojo Editorial Team ExcelMojo Editorial Team ExcelMojo editorial profile and article credentials. Full Bio
Reviewed by Dheeraj Vaidya, CFA, FRM Dheeraj Vaidya, CFA, FRM Reviewed for accuracy, clarity, and editorial standards. Full Bio
Updated Apr 28, 2026
Read Time 7 min

What Is Square Root Formula In Excel (SQRT)?

The Square Root in Excel (SQRT) is an arithmetic function used to find the square root of a given number or an integer. The Excel Square Root is an inbuilt “Math and Trig” function, so we can insert the formula from the “Function Library” or enter it directly in the worksheet.

For example, the image depicts the set of values, and we will calculate Square Root in Excel using the SQRT formula.

Frequently Asked Questions (FAQs)

1. How do I do Square Root in Excel?

The following example depicts the set of values, and we will calculate Square Root in Excel using the SQRT Excel formula.

In the table, the data is,
• Column A contains the Value.
• Column B contains the Output.

Square Root in Excel (SQRT) - FAQ 1

The steps to evaluate the values to find the Square Root in Excel are as follows:

• Step 1: Select cell B2, enter the formula =SQRT(ABS(A2)), and press the “Enter” key. The result is “7”, as shown below.

FAQ 1 - Step 1

• Step 2: Drag the formula from cell B2 to B6 using the fill handle. The output is shown below.

FAQ 1 - Step 2

2. How to Calculate the Square Root of a Number Using the POWER Function?

The Square Root of a Number using the POWER Function illustrates the number of times a number is multiplied by itself.

The syntax of the POWER function is =POWER(number,power)

The following example depicts the set of values, and we will calculate Square Root in Excel using the POWER Excel formula.

In the table, the data is,
• Column A contains the Value.
• Column B contains the Output.

Square Root in Excel (SQRT) - FAQ 2

The steps to evaluate the values by calculating Square Root in Excel using the POWER function are as follows:

• Step 1: Select cell B2, enter the formula =POWER(A2,1/2), and press the “Enter” key. The result is “12”, as shown below.

[Note: The cell that contains a number, i.e., “A2”, and the cell that contains power, i.e., “1/2”.]

FAQ 2 - Step 1

• Step 2: Drag the formula from cell B2 to B6 using the fill handle. The output is shown below.

FAQ 2 - Step 2

3. What is the shortcut of the Square Root in Excel (SQRT)?

The shortcut of the Square Root in Excel (SQRT) is as follows:

Square Root in Excel (SQRT) - FAQ 3

Download Template

📥Download the ready-to-use Excel template to practice this tutorial yourself.

Download Excel Template

This has been a guide to Square Root In Excel (SQRT). Here we learn how to find square root of numeric value along with examples & downloadable excel template. You can learn more from the following articles –