| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I copy a value from a cell and paste it into another cell while adding it to the previous value in that cell | Excel Worksheet Functions | |||
| I copy a formula and the results copy from the original cell | Excel Discussion (Misc queries) | |||
| Copy data in one cell to blank cell immediately below, repeat | Excel Worksheet Functions | |||
| Data entry - Copy contents of cell typed in one cell to another ce | Excel Worksheet Functions | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Linear Mode
