It compares 2 strings and returns TRUE if they are exactly the same. It is case-sensitive.
The syntax of the function is the following:
EXACT(text1, text2)
text1, text2 : The two text strings to compare.
Click on the button to practice using this function, with the help of our Online Assessment Tool:
Here is an example of how to use the EXACT function:
In the cell range C1:C4 use the proper function to return TRUE if the respective cells of the columns A and B are exactly the same.