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
|