Formula to find equal values with blank cells
 

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.

Formula to find equal values with blank cells
 

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

Formula to find equal values with blank cells
 

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

Formula to find equal values with blank cells
 

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.

Formula to find equal values with blank cells
 

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.

Formula to find equal values with blank cells
 

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