You are here:
MIN
Returns the lowest number from a list of numbers.
Use
MIN(number,
number,...) and replace number with the fields
or expressions from which you want to retrieve the lowest number.
MIN(250, Contribution__c /2)This example formula determines which amount to provide in employee 401K matching based on a matching program of half of the employee's contribution or $250, whichever is less. It assumes you have a custom currency field for Contribution.
MIN(Gross__c * Bonus_Percent__c,
Performance__c / Number_of_Employees__c)This example determines an employee's bonus amount based on the smallest of two amounts: the employee's gross times bonus percent or an equally divided amount of the company's performance amount among all employees. It assumes you have a custom number field for Number of Employees, a custom percent field for Bonus Percent, and currency custom fields for the employee's Gross and company's Performance.
