The SQRT function in Google Sheets is useful when you need to find the positive square root of a number.
The square root function is a common operation in mathematics. This particular function only works for positive numbers.
The rules for using the
SQRT function in Google Sheets are as follows:
- The function requires a single argument. The
SQRTfunction requires the number for which to calculate the positive square root.
- The output returned is the positive square root as a result.
Let’s take a look at an example of this function in use.
The Pythagorean Theorem is one of the most common formulas taught in the classroom. It’s needed in all types of fields, from physics to architecture. But for this particular example, we simply need to compute the diagonal of a grassy field.
We know that the field’s length is 175 m and that the width of the field is 95m. How do we solve for the diagonal?
From the Pythagorean theorem, we can derive the equation for solving the diagonal as c = a^2+b^2. Using the
SQRT function, we can easily compute for the value of c.
This example is just one way we can use the
SQRT function in Google Sheets. The square root is essential for so many equations, including equations in trigonometry, calculus, and more.
In the next section, let’s figure out how to write the
SQRT function ourselves in Google Sheets.
The Anatomy of the SQRT Function
The syntax of the
SQRT function is as follows:
Let’s dissect this thing and understand what each of these terms means:
- = the equal sign is how we start any type of function in Google Sheets.
- SQRT() is our
SQRTfunction. It computes the positive square root of a number
- value refers to the number which we want to find the square root of.
- The value argument must be a positive number, else the function will return a #NUM! error
A Real Example of Using SQRT Function
Let’s look into an example of the
SQRT function being used in a Google Sheets spreadsheet.
In the worksheet below, we have typed in the length and width of our example earlier. Using the
SQRT function in Google Sheets, we find out that the diagonal of the field is 199.123 m long.
To get the values in cell B3, we just need to use the following formula:
In the second example below, we have values for sides a and b of multiple right triangles. Using the
SQRT function, we’re able to find the values of the hypotenuse.
If you would like to try out these worksheets yourself, you may use the link attached below to make your own copy.
Are you ready to try out the
SQRT function in Google Sheets? Let’s begin writing it ourselves in the next section.
How to Use SQRT Function in Google Sheets
In this step-by-step guide, we’ll be building the second example shown earlier.
- We must first select the cell we will add our formula to first. In this example, we’ll start with cell D2.
- Next, we just have to type the equal sign ‘=‘ to start our function, followed by ‘SQRT(‘.
- After typing in our function name, you may see a pop-up showing information about the function you just typed. If you would like to minimize this tooltip, you may click the arrow in the top-right-hand corner.
- The next step is to type our argument. Following the Pythagorean Theorem, we can use the following formula to get the first row’s result: =SQRT(B2^2 + C2^2)
Afterward, simply hit Enter on your keyboard to let the function evaluate.
- Finally, we can drag down the formula in cell D2 to fill out the rest of the table!
Frequently Asked Questions (FAQ)
- How do I find out the square root of a negative number?
SQRTfunction does not accept negative numbers as valid input. A possible workaround for this is to use the
ABSfunction gets the absolute value of a given number. For example,
=ABS(-10)is simply 10.
In the example below, we’ve wrapped our
SQRTargument with an
ABSfunction first in order to get the square root of a negative number.
- Is it possible to find the square root of a number without having to use the SQRT function?
It’s possible to find the square root of numbers by using the ‘^’ operator. We just need to raise the number to 0.5. For example, =100^0.5 is simply 10.
Hopefully, you now know more about the
SQRT function in Google Sheets. This guide shows how easy it is to use the square root operation in Google Sheets.
You can now use the
SQRT function in Google Sheets together with the various other Google Sheets formulas available to create powerful spreadsheets for any kind of computation.
If this article was informative, you can opt to stay notified of new guides like this by subscribing to our newsletter!