Formula to find equal values with blank cells

[Guest]

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.

 

[Guest]

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

Dave

 

[Guest]

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

hth

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



"hilltop55" escreveu:

 

[Sandy Mann]

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Guest]

Hi,

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

Thanks

 

[Sandy Mann]

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk