if cell is greater than or less than

[TMoll]

I am new to this forum, and am very new at creating formulas. All I need for now, is to repeat a number if it is greater than zero. and likewise, if less than zero in the next column.
Thanks!

 

[VoG]

Try something like

=IF(A1<>0,A1,"")

 

[Special-K99]

You're going to have to explain in more detail, upload a dummy spreadsheet to an online storage site and post a link to it here as you can't attach spreadsheets on this forum.