The Excel Exact Function

Basic 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 format 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.

Exact Function Examples

The following spreadsheet shows examples of the Excel Exact function.

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

Note that, in the above examples:

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