Copy Cell

Saz · Apr 25, 2008

Hi,

How can I copy Copy whole column C to F but if any cell in column C
has null value, it should display as Unknown?

Thank you,
Saz

Per Jessen · Apr 25, 2008

Hi

Use this formula in F1 and copy it down.

=IF(C1,C1,"Unknown")

Regards,
Per