日记首页
|
列表
|
添加日记
|
管理登陆
标题：Excel中，=INDIRECT函数
<div><font face="Arial"><span style="font-size: 14px;">在Excel中，</span></font><span style="color: rgb(51, 51, 51); font-family: "Helvetica Neue", Helvetica, Arial, "PingFang SC", "Hiragino Sans GB", "Microsoft YaHei", "WenQuanYi Micro Hei", sans-serif; font-size: 14px; text-indent: 28px;">=INDIRECT</span><font face="Arial"><span style="font-size: 14px;">函数，可使插入行单元格后可以保持公式原有单元格不变。</span></font></div><div style="font-family: Arial;"><span style="font-size: 14px;"><br></span></div><div style="font-family: Arial; font-size: 14px;"><span style="color: rgb(51, 51, 51); font-family: "Helvetica Neue", Helvetica, Arial, "PingFang SC", "Hiragino Sans GB", "Microsoft YaHei", "WenQuanYi Micro Hei", sans-serif; text-indent: 28px;">比如:</span></div><div style="font-family: Arial; font-size: 14px;"><span style="color: rgb(51, 51, 51); font-family: "Helvetica Neue", Helvetica, Arial, "PingFang SC", "Hiragino Sans GB", "Microsoft YaHei", "WenQuanYi Micro Hei", sans-serif; text-indent: 28px;">某单元格</span><span style="color: rgb(51, 51, 51); font-family: "Helvetica Neue", Helvetica, Arial, "PingFang SC", "Hiragino Sans GB", "Microsoft YaHei", "WenQuanYi Micro Hei", sans-serif; text-indent: 28px;">=INDIRECT("A4")</span></div><div style="font-family: Arial; font-size: 14px;"><span style="color: rgb(51, 51, 51); font-family: "Helvetica Neue", Helvetica, Arial, "PingFang SC", "Hiragino Sans GB", "Microsoft YaHei", "WenQuanYi Micro Hei", sans-serif; text-indent: 28px;">表示：</span><font color="#333333" face="Helvetica Neue, Helvetica, Arial, PingFang SC, Hiragino Sans GB, Microsoft YaHei, WenQuanYi Micro Hei, sans-serif" style="font-size: medium; text-indent: 28px;"><span style="font-size: 14px;">某单元格等于A4单元格的值。前面插入行，</span></font><span style="text-indent: 28px; color: rgb(51, 51, 51); font-family: "Helvetica Neue", Helvetica, Arial, "PingFang SC", "Hiragino Sans GB", "Microsoft YaHei", "WenQuanYi Micro Hei", sans-serif;">某单元格任然等于新的A4的</span><span style="text-indent: 28px; color: rgb(51, 51, 51); font-family: "Helvetica Neue", Helvetica, Arial, "PingFang SC", "Hiragino Sans GB", "Microsoft YaHei", "WenQuanYi Micro Hei", sans-serif;">值。</span></div><div style="font-family: Arial; font-size: 14px;"><span style="color: rgb(51, 51, 51); font-family: "Helvetica Neue", Helvetica, Arial, "PingFang SC", "Hiragino Sans GB", "Microsoft YaHei", "WenQuanYi Micro Hei", sans-serif; text-indent: 28px;"><br></span></div><div style="font-family: Arial; font-size: 14px;"><span style="color: rgb(51, 51, 51); font-family: "Helvetica Neue", Helvetica, Arial, "PingFang SC", "Hiragino Sans GB", "Microsoft YaHei", "WenQuanYi Micro Hei", sans-serif; text-indent: 28px;"><br></span></div><div style="font-family: Arial; font-size: 14px;"><span style="color: rgb(51, 51, 51); font-family: "Helvetica Neue", Helvetica, Arial, "PingFang SC", "Hiragino Sans GB", "Microsoft YaHei", "WenQuanYi Micro Hei", sans-serif; text-indent: 28px;">与之相反：</span></div><div style=""><span style="text-indent: 28px; font-size: 14px;"><font color="#333333" face="Helvetica Neue, Helvetica, Arial, PingFang SC, Hiragino Sans GB, Microsoft YaHei, WenQuanYi Micro Hei, sans-serif">=OFFSET($A$1,COUNTA(A:A)-1,)</font></span></div><div style=""><span style="text-indent: 28px; font-size: 14px;"><font color="#333333" face="Helvetica Neue, Helvetica, Arial, PingFang SC, Hiragino Sans GB, Microsoft YaHei, WenQuanYi Micro Hei, sans-serif">表示：不管A列有多少数据，都会显示A列最后一行数据。</font></span></div><div style=""><span style="text-indent: 28px; font-size: 14px;"><font color="#333333" face="Helvetica Neue, Helvetica, Arial, PingFang SC, Hiragino Sans GB, Microsoft YaHei, WenQuanYi Micro Hei, sans-serif"><br></font></span></div><div style=""><br></div>
