![](http://tiebapic.baidu.com/forum/w%3D580/sign=b5b5321a764e251fe2f7e4f09787c9c2/cf14dd54564e9258258816ceda82d158ccbf4e0e.jpg?tbpicau=2025-03-03-05_659172d091d6edf11c9707ca2291c3eb)
所需经验=IFERROR(VLOOKUP($C4,$J$8:$K$22,2,FALSE),IFERROR(VLOOKUP($C4,$L$8:$M$22,2,FALSE),IFERROR(VLOOKUP($C4,$N$8:$O$22,2,FALSE),VLOOKUP($C4,$P$8:$Q$22,2,FALSE))))-$B4
所需天数=ROUNDUP($D4/(IF($E4="普通",$K$4,$L$4)+IF($E4="普通",$O$3,INDEX($N$4:$V$6,MATCH($E4,$N$4:$N$6),MATCH($F4,$N$4:$V$4)))),0)