Formatting
 

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.

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