EXACT (Text1,Text2)
- and are text string.
Description
- This function checks the two text string values are identical or not.
- This function will give the result in a logical values.
- The result is TRUE when the two strings are similar and the result is FALSE when the two strings are different.
- function is the similar to the comparison operator (==).
- So we can use the operator(==) instead of this function.
- The string values we have to give with in double quotes.
Examples
- EXACT("life","life") = true
- EXACT("life","Life") = false
- EXACT("LIFE","Life") = false
- EXACT("l ife","life") = false
- EXACT("45","45") = true
- EXACT("7","-7") = false
Related Videos
See Also
References