Excel: Entering empty cells with function

[24forChromium]

How can I set up a function with an if command such that it only copies values greater than zero from another column while leave the rest of the cells empty (not zero)?

 

[Borg]

How can I set up a function with an if command such that it only copies values greater than zero from another column while leave the rest of the cells empty (not zero)?

Use an if statement like this. To copy the value of cell A1, use this in the cell that you want it copied to.
=IF(A1>0,A1,"")

http://www.exceltrick.com/formulas_macros/excel-if-statement/