Search

 

Module: Editor

Version: 5.1.4 +

Type: Boolean

Category: Matrix

 

Description

The formula 'IsEqual' checks whether a logical test is true or false with the condition that the elements of a matrix are equal to the elements of another matrix. The two matrices have to be of the same size. The matrices can contain real numbers, integers, dates, booleans or text.

Parameters

Number1:            the first matrix you want to use for the logical test.

Number2:            the second matrix that you want to use for the logical test.

Example

Description

In the following example the formula 'IsEqual' is used to check whether the elements of a matrix are equal to the elements of a another matrix.

Values parameters

Number1:

Column 1Column 2
 10  3
 2  40

 

Number2:

Column 1Column 2
 1  30
 20  4

 

Result

Output:

Column 1Column 2
 False  False
 False  False

 

The outcome is a matrix with the results of the logical tests on each element of the two matrices with the same position.

10 = 1: False

2 = 20: False

3 = 30: False

40 = 4: False

Related Topics

IsNotEqual: The formula 'IsNotEqual' checks whether a logical test is true or false with the condition that the elements of a matrix are not equal to the elements of another matrix. 

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-16