excel 除法条件的函数公式怎么写?
发布网友
共2个回答
热心网友
C1:=textjoin(";",1,IF(MOD(A1,B$1:B$20),"",B$1:B$20))
ctrl+shift+回车，下拉
热心网友
在C1中输入或复制粘贴下列公式之一
=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,""))
下拉填充
