Difference between revisions of "Manuals/calci/EXACT"
Jump to navigation
Jump to search
Line 12: | Line 12: | ||
==Examples== | ==Examples== | ||
#EXACT("life","life") = TRUE | #EXACT("life","life") = TRUE | ||
− | #EXACT("life",Life") = FALSE | + | #EXACT("life","Life") = FALSE |
#EXACT("LIFE",Life") = FALSE | #EXACT("LIFE",Life") = FALSE | ||
#EXACT("l ife","life") = FALSE | #EXACT("l ife","life") = FALSE | ||
#EXACT("45","45") = TRUE | #EXACT("45","45") = TRUE | ||
− | #EXACT("7","-7") = FALSE | + | #EXACT("7","-7") = FALSE |
==Related Videos== | ==Related Videos== |
Revision as of 10:34, 10 October 2015
EXACT(t1,t2)
- 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