SQRT or Square Root function in excel is an inbuilt arithmetic function which is used to calculate square root if a given number in excel, to use this function in excel we need to type the keyword =SQRT( and press tab button which will pop up the SQRT function for us, this function takes a single argument.
The SQRT function syntax has the following arguments:
- Number (required argument) – This is the number for which we wish to find out the square root. It must be a positive number, an Excel formula, or a function that results in a positive number.
Example: Let’s look at some Excel SQRT function examples and explore how to use the SQRT function as a worksheet function in Microsoft Excel:
Based on the Excel spreadsheet above, the following SQRT examples would return:
- SQRT in excel can accept only numbers. If you supply anything other than the numerical value we will get VALUE!
- SQRT function in excel an accepts only positive numbers. If you supply negative numbers it will return the result as #NUM!
- In order to insert the square root symbol hold the ALT key and type 251 from number keypad.