Compares two data items and evaluates to true or false.
Syntax
=(equals)<>(does not equal)<(less than)>(greater than)<=(less than or equal to)>=(greater than or equal to)
All of the comparators can be used to compare longs, doubles, money and text (strings).
The following comparators can be used to compare dates:
= (equals)
<> (does not equal)
Examples
Today()=Date(2013,12,12)
if(Cost < Revenue, “profit”, “loss”)