excel :用公式 =COUNTIF(AW12:AW51,">=700")计算时，若返回的值为0，如何显示为空格

Question

=COUNTIF(AW12:AW51,">=680")-COUNTIF(AW12:AW51,">689")怎么办？我尝试改了一下，出问题了，系统自动更正后，没看出来有什么变化，不放心，请高手给改一下

Answer 1

　　虽然已有满意回答, 但还是要说一下, 如果公式很长的话, 不妨考虑下面这个方法:

　　屏蔽零值

=text(COUNTIF(AW12:AW51,">=700"),"G/通用格式;-G/通用格式;;@")

=TEXT(COUNTIF(AW12:AW51,">=680")-COUNTIF(AW12:AW51,">689"),"G/通用格式;-G/通用格式;;@")

　　简单点说就是把你的公式套到TEXT格式中屏蔽零值

TEXT(原公式,"G/通用格式;-G/通用格式;;@")

Answer 2

再套一个IF函数
IF 为零则为空格
=IF(COUNTIF(AW12:AW51,">=700") = 0 ,"",COUNTIF(AW12:AW51,">=700"))追问

=COUNTIF(AW12:AW51,">=680")-COUNTIF(AW12:AW51,">689")怎么办

追答

一样
=if (COUNTIF(AW12:AW51,">=680")-COUNTIF(AW12:AW51,">689") = 0 ,"",COUNTIF(AW12:AW51,">=680")-COUNTIF(AW12:AW51,">689"))

本回答被提问者采纳