Description
The Excel EXACT function is another condition function that returns logical values.
Thus if the condition is met, Excel returns the TRUE result otherwise it returns the text FALSE.
Conditional functions play a major role in dynamic Excel modeling as these provide the opportunity to vary results if the particular scenario changes.
Logical Value means TRUE or FALSE text, either written or returned from a function.
In Excel EXACT function if the text in referred cells is not the same, it means the condition is not met and the FALSE result will be returned.
NOTE:- The EXACT function is case sensitive and even if the text is the same but in a different case ( Propper, Lower, Upper), this function will return the FALSE result.
This can be illustrated in the example given in the image above. B5, B6, and B7 all contain the same text i.e. Excel but as in cell B7, the word is written upper case.
=EXACT(text1,text2)
The EXACT function’s syntax has the following arguments:
- text1 Required.
The text1 argument refers to the 1st text required to be compared with the 2nd text.
- text2 Required.
The text2 argument refers to the 2nd text required to be compared with the 1st text.
NOTE:- This function takes only two test arguments.
