This question already has an answer here:
这个问题已经有了答案:
- Pulling data from big excel datatable with incremental column in Vlookup or IndexMatch without zeros 2 answers
- 在Vlookup或IndexMatch中使用增量列从大excel数据表中提取数据，不需要0个答案
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.
如果这个单元格是空的，我希望这个页面上的单元格也是空的，而不是0。我该怎么做呢?我希望它对任何人来说都是空的，而不仅仅是我，所以我不认为简单地编辑excel设置就可以工作?我的谷歌搜索结果，包括MS office网站，都没有任何帮助。
1 个解决方案
#1
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.
看看这个问题的答案。
#1
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.
看看这个问题的答案。