Manuals/calci/EXACT
Jump to navigation
Jump to search
EXACT(txt1,txt2)
where txt1 is the first text string and txt2 is the second text string.
EXACT compares two text strings . It is used to test text being entered into a document.
EXACT
Let’s see an example in (Column1 Row 1,Column2Row1)
I.e.=EXACT(C1R1,C2R1)
=EXACT(flower,flower) is 1(which means it is true)
I.e.=EXACT(C3R1,C4R1)
=EXACT(flower,flowers) is 0 which means it is false
Syntax
Examples
Description
Column1 | Column2 | Column3 | Column4 | |
Row1 | flower | flower | flower | flowers |
Row2 | 1 | 0 | ||
Row3 | ||||
Row4 | ||||
Row5 | ||||
Row6 |