WPS或者EXCEL的函数

2025-04-05 10:36:39
推荐回答(2个)
回答1:

=IF(COUNTIF(A2:C2,A1)>0,"有","无")

回答2:

=IF(COUNTIF(A2:C2,A1),"有","无")