怎么用excel里面的函数公式写这个提成比例。在线等电子表格高手指导...答:1、输入=CEILING(A4*20,1)*2 2、输入=IF(A4<=800,0,IF(A4<=100,5,IF(A4<=1300,10,IF(A4<=1600,15,20)))*1 3、输入=IF(A4<=0.6,0.2,IF(A4<=0.65,0.25,IF(A4<=0.7,0.31,IF(A4<=0.75,0.38,IF(A4<=0.8,0.46,0.55)))...
求大神赐教,我想设置一个公式用IF任务在这个范围内,提成显示相应值答:A1为任务完成率 =LOOKUP(A1,{0,0.95,1.15,1.25,1.35}-0.001,{1,1.4,1.6,1.8,2})