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