SQRT Function in Excel

SQRT Function in Excel

In this post, you will learn about the SQRT Function in Excel, how to use it in your excel spreadsheets.

SQRT Function in Excel

The SQRT function returns the square root of the given positive number. The function returns an error when negative numbers are used.

Syntax

=SQRT(number)

The syntax has one argument

  • number – This argument holds the number which you want to find the square root for

How does the SQRT Function work in Excel?

  • To start, enter the numbers in the excel sheet. In a new cell enter the syntax and highlight the data to include it in the function.
How does the SQRT Function work in Excel?
  • Press enter to display the answer and use the fill handle to apply the function to the rest of the data.
How does the SQRT Function work in Excel?

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

In this post, you’ll learn how to Find Blank cells in excel so that you can remove or delete the blank cells form...
In this article, you’ll learn what is a Gauge Chart in Microsoft Excel. Also, you will learn how to add...
Microsoft Excel provides a shortcut for the users to move columns in excel using two different ways – using Shift...