EXACT Function (Functions in Excel)
Text1 | Text2 | Result | |
Hello | Hello | TRUE | =EXACT(C4,D4) |
Hello | hello | FALSE | =EXACT(C5,D5) |
Hello | Goodbye | FALSE | =EXACT(C6,D6) |
What Does It Do? |
This function compares two items of text and determine whether they are exactly the same. |
The case of the characters is taken into account, only words which are spelt the same and |
which have upper and lower case characters in the same position will be considered as equal. |
Syntax |
=EXACT(Text1,Text2) |
Only two items of text can be compared. |
Formatting |
If the two items of text are exactly the same the result of TRUE will be shown. |
If there is any difference in the two items of text the result of FALSE will be shown. |
Example |
Here is a simple password checking formula. |
You need to guess the correct password. |
The password is the name of a colour, either red blue or green. |
The case of the password is important. |
The =EXACT() function is used to check your guess. |
Guess the password : | red |
Is it correct : | No |
(To stop you from cheating, the correct password has been entered as a series of =CHAR() |
functions, which use the ANSI number of the characters rather than the character itself!) |
Its still very easy though. |
0 comments:
Post a Comment