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 article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
  • Excel
  • November 23, 2021