View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Farhad Farhad is offline
external usenet poster
 
Posts: 281
Default 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.