如题所述
第1个回答 2017-12-25
C1,D1,F1都为空,则H1显示有空值的表达式为:
=IF(COUNTA(C1,D1,F1)=3,"有空值","")
C1,D1,E1,F1中3个以上为空的,则H1显示有空值表达式为:
=IF(COUNTA(C1:F1)>=3,"有空值","")
=IF(COUNTA(C1,D1,F1)=3,"有空值","")
C1,D1,E1,F1中3个以上为空的,则H1显示有空值表达式为:
=IF(COUNTA(C1:F1)>=3,"有空值","")