The SQRT function returns the square root of a positive number in Excel

The SQRT () function in Excel helps you quickly calculate the square root of any number you want. The syntax and usage of the function is very simple, but if you do not know, follow the article below.

The SQRT function returns the square root of a positive number in Excel Picture 1

The article describes the syntax and usage of the SQRT () function in Excel.

Description

SQRT () returns the square root of a positive number.

Syntax

= SQRT (number)

Inside:

number is a positive number that you want to find its square root.

If number is negative, SQRT () will return a #NUM! Error.

For example

Find the square root of the numbers: 3, -3, 0, 0.5.

Because -3 is a negative number, the function returns the #NUM! Error. other numbers will be returned to their square root value.

The SQRT function returns the square root of a positive number in Excel Picture 2

The article presented the syntax and usage of the SQRT () function in Excel, hopefully the article will help you better understand the SQRT () function. Good luck!

Isabella Humphrey

Update 19 May 2020

You should read it

May be interested

The DAYS function - The function returns the number of days between 2 dates in Excel
days function: the function returns the number of days between 2 dates, the support function from excel 2013 onwards. syntax: days (end_date, start_date)
ISODD function - The function returns True if the value is an odd number in Excel
isodd function: the function returns true if the value is odd. application of functions to check odd and even numbers. syntax: isodd (number)
PERMUTATIONA function - The function returns the number of permutations (can be repeated) of a given object in Excel
permutationa function: the function returns the number of permutations (can be repeated) of a given object. support functions from excel 2013 onwards. syntax: permutationa (number, number_chosen)
GAMMA function - The function returns the gamma function value in Excel
gamma: the function returns the gamma function. support functions from excel 2013 onwards. syntax: gamma (number)
POISSON.DIST function - The function returns the Poisson distribution in Excel
poisson.dist function: the function returns the poisson distribution, the application function to predict the number of events in a specific time. support functions from excel 2013 onwards. syntax: poisson.dist (x, mean, cumulative)
RANK.EQ function - Function returns the rank of a number in a list of numbers, returns the highest rank when multiple values with the same rank in Excel
rank.eq function: the function returns the rank of a number in a list of numbers whose size is in correlation with other values. if multiple values have the same rank -> the function returns the highest rank. support functions from execl 2010 version onwards.
SHEETS function - The function returns the number of pages in a reference in Excel
sheets function: the function returns the number of pages in a reference. support functions from excel 2013 onwards. syntax: sheets (reference)
BETA.DIST function - The function returns the Beta distribution in Excel
beta.dist function: the function returns the beta distribution to study the variability of a number of things through a sample. support functions from excel 2010 onwards. syntax: beta.dist (x, alpha, beta, cumulative, [a], [b])
How to use ADDRESS function in Excel
the address function in excel takes the number of rows and column numbers as arguments and returns the reference of the standard cell (cell address). for example, if you go to row 4 and column 3, the function returns c4.
POISSON function - The function returns the Poisson distribution in Excel
in predicting the number of events that occur within a specific time, one cannot help but use the poisson function. the following article details how to use the poisson function, the function returns the poisson distribution.