=, <>, <, >, <=, >=

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

Related links

Was this helpful?

How can we improve it?

Need more help?

Try these next steps:

true
Search
Clear search
Close search
Google apps
Main menu
3527452879232006232
true
Search Help Center
true
true
true
true
true
5055977
false
false