Comparison

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

Was this helpful?
How can we improve it?