How to Use the SQRT Function in Excel

Today, let’s delve into utilizing the SQRT function within Excel and Google Sheets to compute square roots. This function is invaluable for handling mathematical operations in your spreadsheets. We’ll cover the usage of the SQRT function and go through some applied examples.

How to Use

The syntax for the SQRT function is consistent across both Excel and Google Sheets:

=SQRT(number)

• number – The number for which the square root is desired.

To use this function, simply enter the formula into a cell, substituting “number” with either the specific number or the cell reference of the number whose square root you need. The function will return the square root of the provided value.

Examples

Below are a few examples to demonstrate the SQRT function in practice:

Example 1: Calculating the Square Root of a Number

Imagine you have a number in cell A1 and wish to calculate its square root. Apply the following formula:

=SQRT(A1)

By entering this formula in cell B1, the result will be 4, since the square root of 16 is 4.

Example 2: Calculating Square Roots for a Range of Numbers

If you need to calculate the square roots for a sequence of numbers, such as those in cells A1 to A5, enter the following formula in cell B1 and fill it down to B5:

=SQRT(A1)

As you drag the formula from B1 to B5, Excel or Google Sheets will automatically update the cell references, providing the square roots for each number in the list.

This demonstration highlights the ease and power of the SQRT function for computing square roots within Excel and Google Sheets, making complex calculations straightforward and efficient.

More information: https://support.microsoft.com/en-us/office/sqrt-function-654975c2-05c4-4831-9a24-2c65e4040fdf