=if(a1 = "", "", a1)
--
HTH...

Jim Thomlinson


"Paul Peterson - Velox Consulting, LLC" wrote:

I have a simple formula that inserts a value in a cell from one spreadsheet
into the cell of another spreadsheet. If the source cell doesn't have a
value, the destination cell has a zero in the cell. I would like to display
a blank if the source cell doesn't contain a value - any ideas?

Paul C. Peterson