我只是个初学者,正在努力让这个发挥作用。任何帮助都将不胜感激!
=IF(B2="","",COUNTIF($C:$C,$D2)=0,"无罚款","罚款")
答案1
=IF(B2="","",IF(COUNTIF($C:$C,$D2)=0,"No Penalty","Penalty"))
解释:
- 如果 B2 为空白,则此公式的输出为空白。
- 如果 B2 非空,则继续检查 COUNTIF 的输出是否相等,如果是,则为“无惩罚”,否则为“惩罚”
我只是个初学者,正在努力让这个发挥作用。任何帮助都将不胜感激!
=IF(B2="","",COUNTIF($C:$C,$D2)=0,"无罚款","罚款")
=IF(B2="","",IF(COUNTIF($C:$C,$D2)=0,"No Penalty","Penalty"))
解释: