我在制作动态图表,定义名称时用这个公式=IF(Sheet5!$G$1=1,OFFSET(Sheet5!$B$1,Sheet5!$H$1,1,1,3),IF(Sheet5!$G$1=2,OFFSET(Sheet5!$B$37,Sheet5!$I$1,1,1,3),IF(Sheet5!$G$1=3,OFFSET(Sheet5!$B$69,Sheet5!$J$1,1,1,3),IF(Sheet5!$G$1=4,OFFSET(Sheet5!$B$96,Sheet5!$K$1,1,1,3),IF(Sheet5!$G$1=5,OFFSET(Sheet5!$B$145,Sheet5!$L$1,1,1,3),IF(Sheet5!$G$1=6,OFFSET(Sheet5!$B$199,Sheet5!$M$1,1,1,3),IF(Sheet5!$G$1=7,OFFSET(Sheet5!$B$253,Sheet5!$N$1,1,1,3),)))))))没办法完整输入,是什么原因,求高手指点。
[img]file:///C:\Documents and Settings\Administrator\Application Data\Tencent\Users\183241597\QQ\WinTemp\RichOle\W6(2HA0VZ[MAMZGNB{3103G.png[/img][img=0,1]file:///C:\Documents and Settings\Administrator\Application Data\Tencent\Users\183241597\QQ\WinTemp\RichOle\W6(2HA0VZ[MAMZGNB{3103G.png[/img][img=0,1]file:///C:\Documents and Settings\Administrator\Application Data\Tencent\Users\183241597\QQ\WinTemp\RichOle\W6(2HA0VZ[MAMZGNB{3103G.png[/img]
|