Returns the positive square root of a given number.
Use
SQRT(number) and replace
number with the field or expression you want computed into a square
root.
Tips
- Calculating the square root of a negative number results in an error on the detail page.
- Avoid division by zero errors by including an IF function such as:
IF(Amplitude__c >= 0, SQRT(Amplitude__c), null).
Square Root Example
SQRT(25) returns the square root of 25, which is 5.
Amplitude Example
SQRT(Amplitude__c) returns the square root of a custom
number field representing the amplitude of an earthquake.