if then print/show contents of cell

Don · Sep 14, 2004

Try this:

=IF(AND(A1="",B1=""),"",IF(A1="",B1,""))

HTH,

Don

Don · Sep 15, 2004

Simple enough.....I think....try this:

=IF(AND(A1="",B1=""),"",IF(A1="",B1,A1))