Exact() Function

Exact() Function




The Excel Exact function tests if two supplied text strings or values are exactly equal and if so, returns TRUE; Otherwise, the function returns FALSE. The function is case-sensitive.

Syntax

The syntax for the EXACT function in Microsoft Excel is:

EXACT( text1, text2 )

Parameters or Arguments

text1 and text2

The two string values to compare.

Exact Function Examples

In the following spreadsheet, the Excel Exact function is used to compare four different pairs of text strings.

Formulas:


A
B
C
1
Text
Text
=EXACT( A1, B1 )
2
Text
text
=EXACT( A2, B2 )
3
5321.222
5321.222
=EXACT( A3, B3 )
4
0.5
12:00
=EXACT( A4, B4 )


Results:


A
B
C
1
Text
Text
TRUE

2
Text
text
FALSE

3
5321.222
5321.222
TRUE

4
0.5
12:00
TRUE

Note that, in the above examples:

-          As the Excel Exact function is case-sensitive, the function in cell C2 returns FALSE;
-          The time 12:00 (in cell B4) has the underlying value of 0.5 in Excel. Therefore, the values in cells A4 and B4 are exactly equal.

Comments

Popular posts from this blog

Formatting a Range of Cells In Excel VBA

Trunc() Function

BREAK THE PASSWORD OF THE SHEET IN EXCEL