I need a formula that will look at cell a1 compare it with a2, if exact
return true, if not exact return nothing.

A1 = Bill A2 = Bill return true
A1 = Bill A2 = Sam return true
A1 = Bill A2 is a blank cell; I don't want the word false return just a
blank cell.
--
Thanks for your help.

=IF(A1=A2,"TRUE","")

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"hilltop55" wrote:

I need a formula that will look at cell a1 compare it with a2, if exact
return true, if not exact return nothing.

A1 = Bill A2 = Bill return true
A1 = Bill A2 = Sam return true
A1 = Bill A2 is a blank cell; I don't want the word false return just a
blank cell.
--
Thanks for your help.

=if(a1=a2;"True";"")

hth

--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"hilltop55" escreveu:

I need a formula that will look at cell a1 compare it with a2, if exact
return true, if not exact return nothing.

A1 = Bill A2 = Bill return true
A1 = Bill A2 = Sam return true
A1 = Bill A2 is a blank cell; I don't want the word false return just a
blank cell.
--
Thanks for your help.

You have answers for checking both cells but it depends on what you mean by
EXACT

If you don't want TRUE if A1 = "Sandy" and A2 = "sandy" then use:

=IF(EXACT(A1,A2),TRUE,"Not exact")

If you want to differentiate further use something like:

=IF(A1=A2,IF(EXACT(A1,A2),TRUE,"Close but no cigar"),"Not even close!")

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"hilltop55" wrote in message
...
I need a formula that will look at cell a1 compare it with a2, if exact
return true, if not exact return nothing.

A1 = Bill A2 = Bill return true
A1 = Bill A2 = Sam return true
A1 = Bill A2 is a blank cell; I don't want the word false return just a
blank cell.
--
Thanks for your help.

Hi,

Try this:
=IF(AND(ISBLANK(A1),ISBLANK(A2)),"","TRUE")

Thanks
--
Farhad Hodjat


"hilltop55" wrote:

I need a formula that will look at cell a1 compare it with a2, if exact
return true, if not exact return nothing.

A1 = Bill A2 = Bill return true
A1 = Bill A2 = Sam return true
A1 = Bill A2 is a blank cell; I don't want the word false return just a
blank cell.
--
Thanks for your help.

"Farhad" wrote in message
...
Hi,

Try this:
=IF(AND(ISBLANK(A1),ISBLANK(A2)),"","TRUE")

I misread the OP completely didn't I?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Farhad" wrote in message
...
Hi,

Try this:
=IF(AND(ISBLANK(A1),ISBLANK(A2)),"","TRUE")

Thanks
--
Farhad Hodjat


"hilltop55" wrote:

I need a formula that will look at cell a1 compare it with a2, if exact
return true, if not exact return nothing.

A1 = Bill A2 = Bill return true
A1 = Bill A2 = Sam return true
A1 = Bill A2 is a blank cell; I don't want the word false return just a
blank cell.
--
Thanks for your help.