Arrow left
Back to guides
Excel Formulas

How to Calculate Square Root in Excel (Easy 2-Step Guide)

In this article, you will learn to use the square root function in Excel in two simple steps.

Understanding the SQRT function in Excel

The “=SQRT(number)” formula in Excel calculates the square root of the selected number. For example, if you want to find the square root of the number 16, you can use the formula "=SQRT(16)", which will return the value 4.

When is the SQRT formula helpful in Excel?

The SQRT formula can be used in many different scenarios in Excel, such as when you need to calculate the standard deviation of a data set or when you need to find the length of the hypotenuse of a right angled triangle. Additionally, the SQRT formula can be used in combination with other functions in Excel to perform more complex calculations.

How to use the Square Root formula in Excel? 

Step 1: Click on the cell where you want to calculate the value

Step 2: Type “=SQRT” -> click the formula name in the formula prompt -> select the cell which contains the number -> press “Enter” key

For example: 4 is the value in cell A5. To calculate the square root of 4, you will use “=SQRT(A5)” as shown in the image below.

Image displaying the SQRT function in Excel

Note: If the numeric value input is less than zero, the formula returns #NUM! error value.

Analyze your live financial data in a snap in Google Sheets

Are you learning this formula to visualize financial data, build a financial model, or conduct financial analysis? In that case, LiveFlow may help you automate manual workflows, update numbers in real-time, and save time. You can access various financial templates on our website, from the simple Income Statement to Multi-Currency Consolidated Financial Statement. Are you interested in this product but are an Excel user? That’s not a problem at all. You can connect Google Sheets to Excel quickly. 

To learn more about LiveFlow, book a demo.

Automate any custom financial dashboard in Google Sheets with LiveFlow

You can learn about other Excel and Google Sheets formulas and tips that are not mentioned here on this page: LiveFlow‘s How to Guides

Learn how to do this step-by-step in the video below 👇

Automate financial reporting with LiveFlow

Want to eliminate manual updates of your Excel & Google Sheets models?

Yes, show me how

Need help?

Our team is here to help you any time between 9am and 10pm EST.
Check Icon
Email us at:

Liked this article? Then you'll love the ones below