Formatting

  • Thread starter Thread starter Norma
  • Start date Start date
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If statement combining average 3
Date and If problem 6
Question about conditional formatting of zeros in Excel 0
Getting an average using if statement 3
vlookup or index ?? 3
Leaving a formula cell blank when data has not yet been added. 5
auto fill entered data from one worksheet to another 2
Formula reference formatting 1

Back
Top