EXCEL中如何将多个数组公式合并为一个?答:在J2中输入或复制粘贴下列公式 =IF(I2<=1200,VLOOKUP(H2,A:E,LOOKUP(I2,{0,300,700,900}+10^-5,{2,3,4,5}),),"拆成小包装")下拉填充 如果B1:E1数值分别修改为0.00 300.01 700.01 900.01,公式简化为 =IF(I2<=1200,VLOOKUP(H2,A:E,MATCH(I2,A1:E1),),"拆成小...
excel怎么把两个公式嵌套在一起答:输入=REPLACE(IF(D2<41,70-C2,IF(D2<51,80-C2,IF(D2<100,D2-(RAND()*20+30)+80-C2,IF(D2<300,D2-INT(RAND()*80)+30+80-C2,IF(D2<100000,D2*(RAND()*10+107)/100+80-C2,IF(D2=1444444,D2))),LEN(IF(D2<41,70-C2,IF(D2<51,80-C2,IF(D2<100,D2-(RAND(...