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

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

Excel中条件函数公式怎么写？~

表达不清，表中没有销售或佣金两字，