# The Excel Exact Function

## Function Description

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.

The syntax of the Exact function is:

EXACT( text1, text2 )

Where the text1 and text2 arguments are the two text strings, numbers or logical values that you want to compare for equality.

## Exact Function Examples

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

Formulas:
ABC
1TextText=EXACT( A1, B1 )
2Texttext=EXACT( A2, B2 )
35321.2225321.222=EXACT( A3, B3 )
40.512:00=EXACT( A4, B4 )
5
Results:
ABC
1TextTextTRUE
2TexttextFALSE
35321.2225321.222TRUE
40.512:00TRUE(A4 & B4 both
have value 0.5)
5

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 (it is just the formatting of these two cells that is different).

Further examples of the Excel Exact function are provided on the Microsoft Office website.