== INSTEAD OF EXACT?

[FARAZ QURESHI]

Upon exploring the help on EXACT() Function I came across:

"You can also use the double equals (==) comparison operator instead of the
EXACT function to make exact comparisons. For example, =A1==B1 returns the
same value as =EXACT(A1,B1)."

However, such an expression of "==" is not working!

 

[Dave Peterson]

Where did you read that?

Are you sure that the author was writing about excel?

 

[David Biddulph]

Interesting that the internet help
http://office.microsoft.com/en-gb/excel/HP052090811033.aspx mentions the
double equals, but the built-in help doesn't.

 

[Mike H]

Dave,

It's in Excel 2003 help and I suspect it must be a typo.

Mike

 

[Charles Williams]

Surprising you can find it at:
http://office.microsoft.com/en-us/excel/HP052090811033.aspx

But it does not work.

Charles
__________________________________________________
Outlines for my Sessions at the Australia Excel Users Group
http://www.decisionmodels.com/OZEUC.htm

 

[Mike H]

My built in help (2003) does mention it

Interesting that the internet help
http://office.microsoft.com/en-gb/excel/HP052090811033.aspx mentions the
double equals, but the built-in help doesn't.

 

[David Biddulph]

Well I could have sworn that mine (also Excel 2003) didn't when I looked an
hour or two ago, but now it seems to. It's obviously been too long a week!

 

[Dave Peterson]

I don't see it in xl2003's help for =Exact():

EXACT

See Also

Compares two text strings and returns TRUE if they are exactly the same, FALSE
otherwise. EXACT is case-sensitive but ignores formatting differences. Use EXACT
to test text being entered into a document.

Syntax

EXACT(text1,text2)

Text1 is the first text string.

Text2 is the second text string.

 

[Dave Peterson]

I don't have the online content enabled when I use help and that remark doesn't
show up for me.

But I turned on the online content and tada(!), it showed up.

The authors of the builtin help were less "creative" than the authors of the
online help!

 

[Mike H]

Likewise my online help isn't enabled, here's a copy of my built in help



Compares two text strings and returns TRUE if they are exactly the same,
FALSE otherwise. EXACT is case-sensitive but ignores formatting differences.
Use EXACT to test text being entered into a document.

Syntax

EXACT(text1,text2)

Text1 is the first text string.

Text2 is the second text string.

Remarks

You can also use the double equals (==) comparison operator instead of the
EXACT function to make exact comparisons. For example, =A1==B1 returns the
same value as =EXACT(A1,B1).

Example

The example may be easier to understand if you copy it to a blank worksheet.

etc

Mike

 

[Dave Peterson]

The remarks section doesn't show up for me if the online stuff is not turned on.