=IF(L5<I5,"未完成",IF(L5>=I5<J5,"任务",IF(L5>=J5<K55,"力争",IF(L5>=K5,"奋斗"))))
ABCD四列
D<A,显示未完成
D>=A<B,显示任务
D>=B<C,显示力争
D>=C,显示奋斗
同时哪位高手给个公式,根据D栏计算不同的金额
未达到A,=D*-10
达到A,=D*10
达到B,=D*20
达到C,=D*30
=IF(D1<A1,"未完成",IF(AND(D1>=A1,A1<B1),"任务",IF(AND(D1>=B1,B1<C1),"力争",IF(D1>=C1,"奋斗",""))))
是否如此
|