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!

Where did you read that?

Are you sure that the author was writing about excel?

FARAZ QURESHI wrote:

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

Dave,

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

Mike

"Dave Peterson" wrote:

Where did you read that?

Are you sure that the author was writing about excel?

FARAZ QURESHI wrote:

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

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.


Mike H wrote:

Dave,

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

Mike

"Dave Peterson" wrote:

Where did you read that?

Are you sure that the author was writing about excel?

FARAZ QURESHI wrote:

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


--

Dave Peterson

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

But it does not work.

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

"Dave Peterson" wrote in message
...
Where did you read that?

Are you sure that the author was writing about excel?

FARAZ QURESHI wrote:

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

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

"FARAZ QURESHI" wrote in message
...
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!

My built in help (2003) does mention it

"David Biddulph" wrote:

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

"FARAZ QURESHI" wrote in message
...
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!

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!
:-)
--
David Biddulph

"Mike H" wrote in message
...
My built in help (2003) does mention it

"David Biddulph" wrote:

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

"FARAZ QURESHI" wrote in message
...
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!

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!

David Biddulph wrote:

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!
:-)
--
David Biddulph

"Mike H" wrote in message
...
My built in help (2003) does mention it

"David Biddulph" wrote:

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

"FARAZ QURESHI" wrote in message
...
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

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" wrote:

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!

David Biddulph wrote:

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!
:-)
--
David Biddulph

"Mike H" wrote in message
...
My built in help (2003) does mention it

"David Biddulph" wrote:

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

"FARAZ QURESHI" wrote in message
...
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