Home » Excel-Built-In-Functions » 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 :

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

Examples

The following spreadsheet shows several examples of the Excel Exact function. The format of the function is shown in the spreadsheet on the left and the result is shown in the spreadsheet on the right.

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) actually 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.