=IF(Sheet1!$A$3="","",Sheet1!$A$3)
--
Gary''s Student


"dee" wrote:

Hi,
I have a cell in worksheet2 which references a cell in worksheet 1:
e.g = Worksheet1!A3
But if A3 in woksheet 1 is empty (null?) the cell in worksheet2 has a 0 in it.
Is there any way to get the cell in worksheet2 to also show null?
i need it to show null and not "" because of conditonal formatting I have
thanks!!!