The Excel Exact Function

The Excel Exact function tests if two supplied text strings 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 can be supplied to the function directly or as references to cells containing text.

The Exact function will also work with numbers and logical values


The following spreadsheet shows examples of the Excel Exact function.

  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 )
  A B C D
1 Text Text TRUE  
2 Text text FALSE  
3 5321.222 5321.222 TRUE  
4 0.5 12:00 TRUE (A4 & B4 both have
 the value 0.5 and
 so are exactly equal)

Note that, in the above examples:

Return to the Excel Text Functions Page

Return to the List of All Built-In Excel Functions

Valid XHTML 1.0 Transitional Valid CSS!
Disclaimer   Privacy Policy
Copyright © 2008-2015