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