Formatting

N

Norma

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.
 
J

jlclyde

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.
Click to expand...

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