excel表中,有公式如下,要怎样实现?在公式下拉的过程中,不能实现如下:要怎么样实现?=IF(ISERROR(INDIRECT("'1'!$B8")),"",INDIRECT("'1'!$B8"))=IF(ISERROR(INDIRECT("'1'!$B9")),"",INDIRECT("'1'!$B9"))=IF(ISERROR(INDIRECT("'1'!
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/14 12:47:16
![excel表中,有公式如下,要怎样实现?在公式下拉的过程中,不能实现如下:要怎么样实现?=IF(ISERROR(INDIRECT(](/uploads/image/z/2981922-42-2.jpg?t=excel%E8%A1%A8%E4%B8%AD%2C%E6%9C%89%E5%85%AC%E5%BC%8F%E5%A6%82%E4%B8%8B%2C%E8%A6%81%E6%80%8E%E6%A0%B7%E5%AE%9E%E7%8E%B0%3F%E5%9C%A8%E5%85%AC%E5%BC%8F%E4%B8%8B%E6%8B%89%E7%9A%84%E8%BF%87%E7%A8%8B%E4%B8%AD%2C%E4%B8%8D%E8%83%BD%E5%AE%9E%E7%8E%B0%E5%A6%82%E4%B8%8B%EF%BC%9A%E8%A6%81%E6%80%8E%E4%B9%88%E6%A0%B7%E5%AE%9E%E7%8E%B0%3F%3DIF%28ISERROR%28INDIRECT%28%22%271%27%21%24B8%22%29%29%2C%22%22%2CINDIRECT%28%22%271%27%21%24B8%22%29%29%3DIF%28ISERROR%28INDIRECT%28%22%271%27%21%24B9%22%29%29%2C%22%22%2CINDIRECT%28%22%271%27%21%24B9%22%29%29%3DIF%28ISERROR%28INDIRECT%28%22%271%27%21)
excel表中,有公式如下,要怎样实现?在公式下拉的过程中,不能实现如下:要怎么样实现?=IF(ISERROR(INDIRECT("'1'!$B8")),"",INDIRECT("'1'!$B8"))=IF(ISERROR(INDIRECT("'1'!$B9")),"",INDIRECT("'1'!$B9"))=IF(ISERROR(INDIRECT("'1'!
excel表中,有公式如下,要怎样实现?
在公式下拉的过程中,不能实现如下:要怎么样实现?
=IF(ISERROR(INDIRECT("'1'!$B8")),"",INDIRECT("'1'!$B8"))
=IF(ISERROR(INDIRECT("'1'!$B9")),"",INDIRECT("'1'!$B9"))
=IF(ISERROR(INDIRECT("'1'!$B10")),"",INDIRECT("'1'!$B10"))
=IF(ISERROR(INDIRECT("'1'!$B11")),"",INDIRECT("'1'!$B11"))
下拉时出现的情况是:
=IF(ISERROR(INDIRECT("'1'!$B8")),"",INDIRECT("'1'!$B8"))
=IF(ISERROR(INDIRECT("'1'!$B9")),"",INDIRECT("'1'!$B9"))
=IF(ISERROR(INDIRECT("'1'!$B8")),"",INDIRECT("'1'!$B8"))
=IF(ISERROR(INDIRECT("'1'!$B9")),"",INDIRECT("'1'!$B9"))
excel表中,有公式如下,要怎样实现?在公式下拉的过程中,不能实现如下:要怎么样实现?=IF(ISERROR(INDIRECT("'1'!$B8")),"",INDIRECT("'1'!$B8"))=IF(ISERROR(INDIRECT("'1'!$B9")),"",INDIRECT("'1'!$B9"))=IF(ISERROR(INDIRECT("'1'!
=IF(ISERROR(INDIRECT("'1'!B"&ROW(8:8))),"",INDIRECT("'1'!B"&ROW(8:8)))
下拉