Version: 2.2.1 +
The formula 'IsLess' checks whether a logical test is true or false with the condition that a specified value is smaller than another specified value. The values can be real numbers, integers or dates.
Number1/Date1: the first value or reference that you want to use for the logical test.
Number2/Date2: the second value or reference that you want to use for the logical test.
In the following example the formula 'IsLess' is used to check whether a value is smaller than another value.
The outcome is True, because the logical test 16-4-1980 < 12-5-1980 is True.
- IsLessEqual: The formula 'IsLessEqual' checks whether a logical test is true or false with the condition that a specified value is smaller or equal to another specified value.
If you have any questions about this subject or if you want to provide us feedback please send us an e-mail.