HomeApplicationOffice informationThe SQRT function returns the square root of a positive

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!

5 ★ | 1 Vote

You should read it

May be interested

  • The VALUE function converts a numeric string to a number format in ExcelPhoto of The VALUE function converts a numeric string to a number format in Excel
    the value () function is used to convert a series of numbers to a number.
  • MID and MIDB functions to cut strings in ExcelPhoto of MID and MIDB functions to cut strings in Excel
    the mid () function returns a string from a text string, with the position to start extracting from the text string and the number of characters returned by the string that is specified. functions used in languages ​​use a single-byte character set (sbcs) and always count each character as 1.
  • LOOKUP function searches in ExcelPhoto of LOOKUP function searches in Excel
    the lookup () function returns a value from a data range consisting of 1 column or 1 row, or from an array. the lookup () function is an improvement of the two functions vlookup () and hlookup () because it has the additional function to distinguish the search area as rows or columns.
  • CELL function to look up information of a cell in ExcelPhoto of CELL function to look up information of a cell in Excel
    cell () returns the format, position, or content information of a cell depending on your needs. when you need to look up a cell's information, cell () is the most used function.
  • LEFT and LEFTB functions - Functions for cutting strings in ExcelPhoto of LEFT and LEFTB functions - Functions for cutting strings in Excel
    left () and leftb () are two string-cutting functions that are used a lot in string processing with excel spreadsheets. the left () and leftb () functions help you cut the string to the left of the text string as quickly and efficiently as possible.
  • The OFFSET function returns a reference in ExcelPhoto of The OFFSET function returns a reference in Excel
    the offset () function returns a reference to a range, a cell or a range of cells with the number of rows and columns specified by you. the return reference can be a cell or a range of cells that you can specify the number of rows and columns to return.

Office information