Advanced formula
The basic formula feature is quite restricted and you will likely seek to create more complicated formulas which can be performed by selecting the Advanced Formula tab.
Within this tab, click on Insert Field, choose a field, and then click on Insert.
You can now include merge fields along with advanced operators as well as functions, which are prebuilt Salesforce CRM formulas that you can invoke and pass your input values to by performing following steps :
Tip
Function description and example usage:
Select a function and click on Help to view a description and examples of formulas using that function.
Click on Check Syntax to check your formula for errors.
Enter a description of the formula in the Description box (this is optional).
For formulas that result in either a number, a currency, or a percentage field, you can decide how to display blank fields. To display blank fields as a zero value, select the option Treat blank fields as zeros. To display these fields as blank values...
