Search

 

Module: Editor

Version: 2.2.1 +

Type: Boolean

Category: Logical

 

Description

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.

Parameters

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.

Example

Description

In the following example the formula 'IsLess' is used to check whether a value is smaller than another value.

Values parameters

Date1:          16-4-1980

Date2:          12-5-1980

Result

Output:         True

The outcome is True, because the logical test 16-4-1980 < 12-5-1980 is True.

Related Topics

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.

Feedback

If you have any questions about this subject or if you want to provide us feedback please send us an e-mail.

Updated: 2014-09-26