EXCEL中,三个条件对应三个结果,如何编辑公式。答:=lookup(a1,{-999,1,5},{1,15,2})这里的的{-999,1,5}分别是指当大于等于-999,大于等于1,大于等于5的意思,然后返回后面{1,15,2}中对应位置的值 2.使用嵌套if函数:=if(a1<1,1,if(a1<5,15,2))这里两个公式能达到同样效果,但是需要注意的是lookup函数中的条件是顺着每一个都运行...
excel表中如何满足三个条件就予以奖罚的公式怎么设?答:费死劲了。M3公式:=TEXT(0&MAX(ISNUMBER(FIND(REPT(0,{5,4,3}),TEXT(SUM((N(INDIRECT({"D","F","H","J","L"}&ROW(A3)))>=N(INDIRECT({"C","E","G","I","K"}&ROW(A3)))*10^{4,3,2,1,0}),"00000")))*{5,4,3})-3,"[=2]辞退;[=1]罚款5!0!0;降一...