WPS表格函数如何使用多个条件计算公式?答:在D2中输入或复制粘贴下列公式 =IF(AND(B2="购方",F2="专票"),C2/(1+F2),IF(B2="销方",IF(F2="专票",C2-C2*F2,0),0))或 =IF(F2="专票",IF(B2="购方",C2/(1+F2),C2/(1-F2)),0)下拉填充
wps表格函数公式答:=IF(AND(A1>=1,A1<=10),LOOKUP(A1,{1,2,3,4,5,6,7,8,9,10},{"√","╳","╳","√","≠","≠","√","╳","≠","≠"}),"")