数组相乘或者排列组合在EXCEL上实现的问题答:假如a1:a15与{5,6,7,8,9}5个数相乘,公式=A1:A15*{5,6,7,8,9},返回 {5,6,7,8,9;10,12,14,16,18;15,18,21,24,27;20,24,28,32,36;25,30,35,40,45;30,36,42,48,54;35,42,49,56,63;40,48,56,64,72;45,54,63,72,81;50,60,70,80,90;55,66,77,88,99;60...
excel中数组公式的问题答:G3-IF(G3<4000,800,G3*0.2))*10%*{2,3,4}-1000*{0,2,7} 也就是说,当G3小于4000时,取值为:G3-800*10%*{2,3,4}-1000*{0,2,7} 因为{2,3,4} 和{0,2,7} 是数组形式,所以这里面会出现3个值 当G3大于等于4000时,取值为:G3-G3*0.2*10%*{2,3,4}-1000...