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. |