Question

excel 除法条件的函数公式怎么写？

求助 函数公式怎么写
a列有100个数字，b列有20个数字 a列的每个数字除以b列每个数，除的尽的返回b列的除数，

Answer 1

C1:=textjoin(";",1,IF(MOD(A1,B$1:B$20),"",B$1:B$20))

ctrl+shift+回车，下拉

Answer 2

在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,""))
下拉填充