ExcelBanter - Copy Cell

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Copy Cell (https://www.excelbanter.com/new-users-excel/185061-copy-cell.html)

Saz

Copy Cell

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

Copy Cell

Hi

Use this formula in F1 and copy it down.

=IF(C1,C1,"Unknown")

Regards,
Per

"Saz" skrev i meddelelsen
...
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

All times are GMT +1. The time now is 02:33 AM.