== INSTEAD OF EXACT?

F

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!
 
D

Dave Peterson

Where did you read that?

Are you sure that the author was writing about excel?
 
D

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!
:)
 
D

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.
 
D

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!
 
M

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
 
D

Dave Peterson

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top