The Excel Exact function tests
if two supplied text strings or values are exactly equal and if so, returns
TRUE; Otherwise, the function returns FALSE. The function is case-sensitive.
Syntax
The syntax for the EXACT
function in Microsoft Excel is:
EXACT( text1, text2 )
Parameters or Arguments
text1 and text2
The two string values to
compare.
Exact Function Examples
In the following spreadsheet,
the Excel Exact function is used to compare four different pairs of text
strings.
Formulas:
|
A
|
B
|
C
|
1
|
Text
|
Text
|
=EXACT(
A1, B1 )
|
2
|
Text
|
text
|
=EXACT(
A2, B2 )
|
3
|
5321.222
|
5321.222
|
=EXACT(
A3, B3 )
|
4
|
0.5
|
12:00
|
=EXACT(
A4, B4 )
|
Results:
|
A
|
B
|
C
|
|
1
|
Text
|
Text
|
TRUE
|
|
2
|
Text
|
text
|
FALSE
|
|
3
|
5321.222
|
5321.222
|
TRUE
|
|
4
|
0.5
|
12:00
|
TRUE
|
Note that, in the above examples:
-
As the Excel Exact function is case-sensitive,
the function in cell C2 returns FALSE;
-
The time 12:00 (in cell B4) has the underlying
value of 0.5 in Excel. Therefore, the values in cells A4 and B4 are exactly
equal.
Reference:
follow us on
http://arivilm.blogspot.in
like us on
https://www.facebook.com/Arivilm2501/
No comments:
Post a Comment