EQUALS(data1, data2)


The EQUALS function is used to compare two values. It will return 1 (which is the same as true) if the two values are the same; If the two values are different, then 0 (which is the same as false) is returned.
 
 
Example 1:

##EQUALS("Name", 'Gurli')

If the value of the "Name" field is 'Gurli' then the above formula will return 1 (or true). If the value of the "Name" field is not 'Gurli', then 0 (or false) is returned.


Example 2:

Given that the field "Name" has the value 'Gurli', then the function EQUALS("Name", 'Gurli') will return 1.


Example:

##CASE(EQUALS("Status", 'Closed'), 0, EQUALS("Status", 'Open'), 1, 2) If "Status" has the value "Closed" it will return the result "0".If "Status" has the value "Open" it will return the result "1".If "Status" has neither the value "Closed" nor the value "Open" it will return the result "2".