Loading
Prepare for Email to Become the Default Login ExperienceRead More
Ongoing maintenance for Salesforce HelpRead More
Extend Salesforce with Clicks, Not Code
SQRT

SQRT

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
Square Root Example

SQRT(25) returns the square root of 25, which is 5.

Amplitude Example
Amplitude Example

SQRT(Amplitude__c) returns the square root of a custom number field representing the amplitude of an earthquake.

 
Loading
Salesforce Help | Article