1

I'm not using a numerical formula. All I have is a simple reference to another cell.

=(Sheet1!D8)

If that cell is blank, I want to have the cell on this page blank too, not a 0. How do I do that? I want it to appear empty to anyone, not just me, so I don't think simply editing excel settings would work? None of my google search results, including MS office site, have been helpful.

windbrand222
  • 11
  • 2
  • 2
  • 3

1 Answers1

1

My suggestion:

=IF(ISBLANK(Sheet1!D8),"",Sheet1!D8)

You can force a formula to evaluate as text instead of as a number by adding '& ""' to the end like below, but if you are dealing with numbers this isn't great.

=(Sheet1!D8)&""

See this answer for other ideas.

Community
  • 1
  • 1
Stephen Lloyd
  • 699
  • 6
  • 18