View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default 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.