Compares 2 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”)