=20<30这种写法不合逻辑,而且冗余的括号太多=lookup((SUM(B47:B48)-MOD(SUM(B47:B48),2))/2,{0,20,30,40,50},{0,15,20,25,30}) 或者/2干脆都不要=lookup(SUM(B47:B48)-MOD(SUM(B47:B48),2),{0,40,60,80,100},{0,15,20,25,30}) 在者,SUM(B47:B48)-MOD(SUM(B47:B48),2)还可以简化,你的愿意是奇数减1,偶数不减=lookup(floor(SUM(B47:B48),2),{0,40,60,80,100},{0,15,20,25,30})... |