Excel IF公式返回False值 如何实现条件不匹配时返回空白单元格

问题原因 #

你当前使用的嵌套IF结构未覆盖所有判断分支的返回值：一是最外层IF(B12<>"")没有指定B12为空时的返回结果，二是U12取值判断的最内层IF没有指定匹配失败后的返回结果，因此不符合条件时就会返回默认的FALSE值。

修改后的公式 #

方案1：兼容所有Excel版本，保留原有嵌套逻辑 #

直接补全所有分支的空白返回值即可：

=IF(B12<>"",IF(U12="Subscription","Subscribe",IF(U12="T.E.H.","Subscribe",IF(U12="ESA","Subscribe",IF(U12="Perpetual","Buy",IF(U12=" "," ",""))))),"")

方案2：简化判断逻辑，可读性更强 #

用OR函数合并多个返回Subscribe的判断条件：

=IF(B12="","",IF(OR(U12="Subscription",U12="T.E.H.",U12="ESA"),"Subscribe",IF(U12="Perpetual","Buy",IF(U12=" "," ",""))))

方案3：适用于Excel 2021/365，SWITCH函数更简洁 #

=IF(B12="","",SWITCH(U12,"Subscription","Subscribe","T.E.H.","Subscribe","ESA","Subscribe","Perpetual","Buy"," "," ",""))

修改说明 #

• 补全了最外层IF判断中B12为空时的返回值为空白，避免该场景下返回FALSE
• 补全了U12取值不在预设范围内时的返回值为空白，符合你的需求

内容的提问来源于stack exchange，提问作者Tony