发布网友
共3个回答
热心网友
c1公式=if(a1=b1,"有","无")向下拉
如果有空格可以改为:
=if(trim(a1)=trim(b1),"有","无")
向下拉
热心网友
=IF(A1<>B1,"无","有")
热心网友
=if(a1=b1,"有","无")