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