如果条件为假,则将单元格留空 [英] Leave a cell blank if condition is false
问题描述
= IF(A1 = A2,B2,zz)
然后我自动填充大约350万个单元格+复制 - >粘贴值。然后我找到并用空单元格替换zz。然而,找到和替换一百万个zz字符串是一个非常缓慢的过程。首先我宁愿不要写任何东西。所以我的问题是,如何写下列公式:
= IF(A1 = A2,B2,并且完全不写任何内容)
Excel似乎无法触及单元格,以防万一FALSE(或对此为TRUE)。
单元格包含公式的事实已经意味着它不是真的空。通常的做法是使用空字符串,如
= IF(A1 = A2,B2,)
没有多少情况会出现问题,如果出现问题,大多数情况下有不同的技术可以应用。
Other questions have touched on this and offered solutions that are not viable for a very large data set. I have a formula like the following across 9 columns:
=IF(A1=A2, B2, "zz")
I then autofill about 3.5 million cells + copy -> paste values. Then I find and replace "zz" with "empty cell". However, finding and replacing a million or so "zz" strings is a very slow process. I'd rather not write anything there in the first place. So my question is, how to I write the following formula:
=IF(A1=A2, B2, 'leave cell alone and write nothing there at all')
Excel seems to be incapable of not touching a cell in case of FALSE (or TRUE for that matter).
The fact that the cell contains a formula already means that it is not truly empty. Common practice is to use an empty string, like
=IF(A1=A2, B2,"")
There are not many situations where this will be problematic, and if a problem arises, in most cases there are different techniques that can be applied.
这篇关于如果条件为假,则将单元格留空的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!