excel 除法条件的函数公式怎么写?
发布网友
发布时间：2022-04-23 05:09
共2个回答
热心网友
时间：2022-05-17 17:31
C1:=textjoin(";",1,IF(MOD(A1,B$1:B$20),"",B$1:B$20))
ctrl+shift+回车，下拉
热心网友
时间：2022-05-17 18:49
=TEXTJOIN(",",,IF(A1/B$1:B$20=INT(A1/B$1:B$20),B$1:B$20,""))
=TEXTJOIN(",",,IF(A1/B$1:B$20<>INT(A1/B$1:B$20),"",B$1:B$20))
=TEXTJOIN(",",,IF(MOD(A1,B$1:B$20)>0,"",B$1:B$20))
=TEXTJOIN(",",,IF(MOD(A1,B$1:B$20)=0,B$1:B$20,""))
下拉填充
