...完成回款目标的70%提4.5%,完成回款目标的60%提4%,excel怎么写...答:=INDEX({0.02,0.04,0.045,0.05},MATCH(a1,{0,0.6,0.69,0.8},1))这里设你那个达成率是放在 a1
excel中如果达成率90%发放100元奖励,如果达成100%发放300元奖励怎么...答:在B1中输入或复制粘贴下列公式之一 =IF(A1=100%,300,IF(A1>=90%,100,0))=LOOKUP(A1,{0,90,100}%,{0,100,300})=LOOKUP(A1,{0,0;90%,100;100%,300})
excel公式多条件答:j假设达成率55%那个单元格是F2,在G2输入 =lookup(F2,0.01*{0,45,48,50,52,54,56,58,60,62,64,66,68,10,72,74,76,78},{0,0.3,0.4,0.5,0.6,0.7,0.8,0.85,0.9,0.95,1,1.05,1.1,1.2,1.3,1.45,1.6,1.8})...
求助Excel大神,如图,得分项(标黄)的部分公式应该怎么写呢?答:e3:=D3*LOOKUP(D3,{0,0.8,0.9,1;0,0.4,1,1.1})注意大括号内的一个分号 看题 不准,改为:=D3*LOOKUP(D3,{0,0.8,0.9,1;0,40,100,110})供参考,祝顺利。
EXCEL中IF公式的使用答:C2公式:=IF(A2<>"",IF(A2<0.6,100,IF(A2<0.8,B2*0.8,IF(A2<1,B2*0.9,IF(A2<1.1,B2,IF(A2<1.2,B2*1.2,B2*1.3))),"")下拉即可
excel表格中的百分比怎么用函数满足条件?答:=IF(A1<0.5,0,IF(A1<0.8,300,IF(A1<1,500,800)))或 =LOOKUP(A1,{0,0.5,0.8,1},{0,300,500,800})A1为达成率