View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
NTaylor
 
Posts: n/a
Default keep value if formula has no data

I have a worksheet that automatically updates everyday and works some
calculations for me. How can I get the formula sheet to keep the value from
the previous day if there is no data today. Because now it is filling in all
my cells with zeros. Thanks
--
Nicki Taylor