Hi all,

I would like a cell to give the value of another cell and remain blank if the reference cell is blank. The formula ='cell' (where 'cell' is the reference cell) works well, except when the reference cell is empty - in that case it returns 0 (zero).

What can I do to make the formula return a blank when the reference cell is blank?

Thanks