不知道这个公式哪里出了问题？？？excel里面的。。。。求高手解答。。。

Question

=ROUNDUP(LOOKUP(C4:C25,row($1:$22),{20%,25%,25%,30%,30%,30%,35%,35%,35%,35%,40%,40%,40%,40%,40%,35%,40%,40%,45%,45%,50%,50%})*$E8,0)
改为=ROUNDUP(LOOKUP(C4,row($1:$22),{20%,25%,25%,30%,30%,30%,35%,35%,35%,35%,40%,40%,40%,40%,40%,35%,40%,40%,45%,45%,50%,50%})*$E8,0) 还是不对。。。

Answer 1

{20%,25%,25%,30%,30%,30%,35%,35%,35%,35%,40%,40%,40%,40%,40%,35%,40%,40%,45%,45%,50%,50%}
是不合法的
改成(0.2,0.25....追问

嗯。。没错。。。能告诉我为什么吗？

Answer 2

=ROUNDUP(LOOKUP(C4,ROW($1:$22),{20,25,25,30,30,30,35,35,35,35,40,40,40,40,40,35,40,40,45,45,50,50}%)*$E8,0)