If Statements

[Ben]

I have 3 columns, A, B, and C. Column B is linked to another worksheet and automatically fills up. I want column C to automatically be populated by column C unless a number is put in column A. Column A is input directly by the user and can be any positive or negative number, and can be zero. Please let me know if this is possible.

Thank you.

Ben

 

[Frank Kabel]

Hi
maybe in C1
=IF(A1="",B1,"")
and copy down