我想在excel中添加一个名称,请问下面的函数哪里出错了?if(isnaMATCH(parameters!$G$6,General Sheet!$C$5:$N$5,0),if(parameters!$G$6>General Sheet$N$5,General Sheet!$C$132:$N$132,),offset(General Sheet$C$132,0,0,MATCH(parameters!$G$6,G
来源:学生作业帮助网 编辑:六六作业网 时间:2024/12/19 13:34:36
我想在excel中添加一个名称,请问下面的函数哪里出错了?if(isnaMATCH(parameters!$G$6,General Sheet!$C$5:$N$5,0),if(parameters!$G$6>General Sheet$N$5,General Sheet!$C$132:$N$132,),offset(General Sheet$C$132,0,0,MATCH(parameters!$G$6,G
我想在excel中添加一个名称,请问下面的函数哪里出错了?
if(isnaMATCH(parameters!$G$6,General Sheet!$C$5:$N$5,0),if(parameters!$G$6>General Sheet$N$5,General Sheet!$C$132:$N$132,),offset(General Sheet$C$132,0,0,MATCH(parameters!$G$6,General Sheet!$C$5:$N$5,0),1))
添加名称的时候,总显示parameters!$G$6>General Sheet$N$5这里出错了,我不明白错在哪里.
我想在excel中添加一个名称,请问下面的函数哪里出错了?if(isnaMATCH(parameters!$G$6,General Sheet!$C$5:$N$5,0),if(parameters!$G$6>General Sheet$N$5,General Sheet!$C$132:$N$132,),offset(General Sheet$C$132,0,0,MATCH(parameters!$G$6,G
'General Sheet'!