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

can a cell be both input and output?	3	Nov 14, 2013
Merging cells and formats	8	Jan 5, 2014
If, Or, and	5	Nov 6, 2016
check value in cell	2	Feb 22, 2013
=substitute	2	Aug 18, 2013
Show a cell's formula in text format in a linked cell	2	Jan 27, 2013
Show value from one cell in another cell if today falls between a date range	5	Jan 31, 2013
Referencing the values of multiple cells in conditinal formatting.	0	Jun 27, 2012

Ask a Question