View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Values from referenced cells

Instead of:
=Sheet2!E29
use:
=IF(Sheet2!E29="","",Sheet2!E29)
--
Gary''s Student - gsnu200855


"Wavequation" wrote:

I have a worksheet that references cells in another worksheet. Empty cells
in the referenced sheet are showing up in the second sheet as "0", rather as
an empty cell. I would like them to show up empty. Is there any way to do
this?
Thanks for your help.