Thread: Formatting
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
jlclyde jlclyde is offline
external usenet poster
 
Posts: 410
Default Formatting

On Apr 30, 4:05*pm, Norma wrote:
I am creating a report where the information is drawn from another report. *
The issue I am having is because this is an ongoing report any cell in the
original report that does not have information is showing a "0". *How can I
get the cells to remain blank if there is no data in the original spreadsheet.


Norma,
Try =IF(Cell on original sheet ="","",Cell on original sheet)
Jay