求助excel 高手啊~~帮忙解决个有关IF函数的公式问题~万分感激答:=IF(A1<>"",LOOKUP(A1,{0,24,36,48,60},{0,2000,6000,10000,20000}),"")直接按照销售业绩评定结果计算奖金(如销售业绩评定结果在A1)=IF(A1<>"",LOOKUP(A1,{"不合格","合格","良好","优秀","优异"},{0,2000,6000,10000,20000}),"")最好建立一个业绩考核表,这样今后考核标准...
Excel四种条件选择一个的公式问题答:12<DATEDIF(D2,E2,"m")<=24 这样的写法是错误的,应写成 AND(DATEDIF(D2,E2,"m")>12,DATEDIF(D2,E2,"m")<=24 整个公式可以简写成 =F2*IF(DATEDIF(D2,E2,"m")<=12,0.8,IF(DATEDIF(D2,E2,"m")<=24,0.65,IF(DATEDIF(D2,E2,"m")<=36,0.5,)))再或 =F2*LOOKUP(...