excel 如何将两个单元格里的内容根据逗号分别相乘,谢谢各位大神!_百度...答:只有编写一个自定义函数 函数代码如下 function mm(Sa as string,Sb as string) as stringdim arr,Brr,iarr=split(Sa,",")Brr=split(Sb,",")for i=lbound(arr) to ubound(Brr) Arr(i)=arr(i) & "*" & brr(i)next imm=join(arr,";")end function 函数用法如下:=mm(A1,B1)...