Returns a positive square root of the number passed to the function.
= SQRT(value)
value |
A number whose square root is to be calculated. The number can be specified as an integer (e.g., 37), a decimal value (e.g., 37.48), as a string, or as the value of a variable (e.g, UnitPrice). |
Decimal number.
In the case of an error, the function displays an error message: “SQRT(value): Error message”
The function can be used in combination with other functions.
Example |
Returns |
= SQRT(3.79) |
1.94679223339318 |
= SQRT(“95%”) |
0.974679434480896 |
= SQRT(-3.79) |
“Error: SQRT(-3.79): Value was either too large or too small for a decimal.” |
= SQRT(UnitPrice) |
The square root of UnitPrice. |
= SQRT(“abcd”) |
Displays message “SQRT(abcd): Input string was not in a correct format.” |
= POWER(SQRT(UnitPrice), 3) |
The square root of UnitPrice, raised to the power of 3. |
= MAX(SQRT(UnitPrice), 12) |
The maximum among the square root of UnitPrice and the number 12. |