Copy Cell

  • Thread starter Thread starter Saz
  • Start date Start date
S

Saz

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
 
Hi

Use this formula in F1 and copy it down.

=IF(C1,C1,"Unknown")

Regards,
Per
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If values of Cell are Null........... 1
Cell Formating (concatenate two cells) 4
Excel VBA 1
How do you sort the data by the month of the date? 3
How do you sort the data by the month of the data? 3
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Need Help Merging Cells 2
Excel Help to copy information from one row at a time to another sheet 1

Back
Top