|If you are copying from Sheet 1 to Sheet 2 starting at cell A1 try this:|
=IF(logical test, value if true, value if false)
=IF(Sheet1.A1>0, Sheet1.A1," ")
You can drag this out for the row width and column depth.
EDIT: The IF formula is placed in cells that are in Sheet 2. The original data is in sheet 1. I hope this helps. if this is not clear let me know and I will try to clarify further.
message edited by dcutl002