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