Formula to find equal values with blank cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
=if(a1=a2;"True";"")

hth

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



"hilltop55" escreveu:
 
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
 
Farhad said:
Hi,

Try this:
=IF(AND(ISBLANK(A1),ISBLANK(A2)),"","TRUE")
Click to expand...

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
 
Back
Top