Excel，“您为该函数输入了太多参数”

Question

=if(C15=0,(B14+(VLOOKUP(C16,,'Locks and Readers per day'!D:E, 2, false))),(B15+(VLOOKUP(C16,'Locks and Readers per day'!D:E, 2,FALSE))))

我究竟做错了什么？

Answer 1

有一个逗号太多了：

=if(C15=0,(B14+(VLOOKUP(C16,'Locks and Readers per day'!D:E, 2, false))),(B15+(VLOOKUP(C16,'Locks and Readers per day'!D:E, 2,FALSE))))