Null not equal to zero

S

SLD

How can I make one cell equal to the text of another
cell - without the null value turning to zero?

Example: A1=A2, but if A1 is empty, I do not want the
return value of zero.
 
R

RagDyer

In A2 enter:

=IF(A1="","",A1)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


How can I make one cell equal to the text of another
cell - without the null value turning to zero?

Example: A1=A2, but if A1 is empty, I do not want the
return value of zero.
 
Top