=IF(ISNA(VLOOKUP(W4,[Book2]Sheet1!$A$2:$B$153,2,0)) 这个公式说我少了边括号.

来源：学生作业帮助网编辑：六六作业网时间：2024/05/25 07:46:33

=IF(ISNA(VLOOKUP(W4,[Book2]Sheet1!$A$2:$B$153,2,0))这个公式说我少了边括号.=IF(ISNA(VLOOKUP(W4,[Book2]Sheet1!$A$

=IF(ISNA(VLOOKUP(W4,[Book2]Sheet1!$A$2:$B$153,2,0)) 这个公式说我少了边括号.
=IF(ISNA(VLOOKUP(W4,[Book2]Sheet1!$A$2:$B$153,2,0)) 这个公式说我少了边括号.

=IF(ISNA(VLOOKUP(W4,[Book2]Sheet1!$A$2:$B$153,2,0)) 这个公式说我少了边括号.
=IF(ISNA(VLOOKUP(W4,[Book2]Sheet1!$A$2:$B$153,2,0),VLOOKUP(W4,[Book2]Sheet1!$A$2:$B$153,2,0))

=IF(ISNA(VLOOKUP(W4,[Book2]Sheet1!$A$2:$B$153,2,0))

明显的左边有三个括号IF(ISNA(VLOOKUP(
右边只有两个括号，所以，IF还少个反括号