MS Excel: EXACT Function (WS)
The Microsoft Excel EXACT function compares two strings and returns TRUE if both values are the same. Otherwise, it will return FALSE.
EXACT Function (Syntax)
The syntax for the Microsoft Excel EXACT function is:
EXACT( text1, text2 )
text1 and text2 are the values to compare.
The EXACT function is case-sensitive.
The EXACT function can be used in the following versions of Microsoft Excel:
- Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000
Type of Excel Function
The EXACT function can be used in Microsoft Excel as:
- Worksheet function (WS)
EXACT Examples (as Worksheet Function)
Let's look at some Excel EXACT function examples and explore how you would use the EXACT function as a worksheet function in Microsoft Excel:
Based on the Excel spreadsheet above, the following EXACT function examples would return:
|=EXACT(A1, A2)||would return FALSE|
|=EXACT(A3, A5)||would return TRUE|
|=EXACT(A3, A4)||would return FALSE|
|=EXACT(A4, "Alphabet")||would return TRUE|