恶梦护士 asa_Excel中的绝对噩梦-CSDN博客

恶梦护士 asa

Well, I should have been working all day, but decided to take a bit of time to relax and catch up on some reading (of RSS feeds). On a technology blog, I saw a link to XtraNormal, where you can write, cast and direct an animated movie. That sounded like more fun than working, so off I went.

好吧，我应该整天都在工作，但决定花点时间放松一下，并赶上一些阅读(RSS提要)的内容。在一个技术博客上，我看到了XtraNormal的链接，您可以在其中编写，投射和导演动画电影。听起来比工作更有趣，所以我离开了。

And here's the first (and probably last) installment in Excel Theatre. Please note the giant spreadsheet in the background. I think it adds to the tension in this dramatic presentation. Just so you know – the dialog is corny, the actors are wooden, the plot is weak and the costumes are pitiful. Other than that, it's pretty good. 😉

这是Excel Theatre中的第一个(可能也是最后一个)。请注意背景中的巨型电子表格。我认为这加剧了这场戏剧性演讲中的紧张气氛。众所周知，对话很老套，演员都是木制的，情节很薄弱，服饰很可怜。除此之外，还不错。 😉

Note: The animated actors had a tough time pronouncing INDIRECT, so I had to spell it IN DIE WRECKED in the script, to make it understandable. Fortunately, that seemed to help, and the key word is clearer in the video now.

注意：动画演员在发音INDIRECT时经历了一段艰难的时光，因此为了使它易于理解，我不得不在DIE WERKED中将其拼写。幸运的是，这似乎有所帮助，现在视频中的关键词更加清晰。

演示地址

间接功能 (The INDIRECT Function)

If you haven't used INDIRECT before, it's a formula that returns a reference to a range, based on a text string. As the video pointed out, you can use an absolute reference to a cell, to "lock" the reference, and keep if from changing if you copy the formula to a different cell.

如果您以前从未使用过INDIRECT，则它是一个基于文本字符串返回对范围的引用的公式。正如视频所指出的，您可以使用对单元格的绝对引用，以“锁定”引用，并在将公式复制到其他单元格时保持不变。

However, if the referenced cell moves, the absolute reference changes to match the new location.

但是，如果引用的单元格移动，则绝对引用将更改以匹配新位置。

For example, in the screenshot below, cell C2 contains an absolute reference to cell A1, and cell C3 contains an INDIRECT formula that refers to cell A1.

例如，在下面的屏幕快照中，单元格C2包含对单元格A1的绝对引用，而单元格C3包含引用单元格A1的INDIRECT公式。

If you insert a blank row at the top of the worksheet, the formula in cell C2 changes, and it now refers to cell A2. Because it's a text string, the reference in the INDIRECT formula doesn't change. It returns a zero because cell A1 is now empty.

如果您在工作表的顶部插入空白行，则单元格C2中的公式将更改，现在它引用单元格A2。由于它是文本字符串，因此INDIRECT公式中的引用不会更改。它返回零，因为单元格A1现在为空。

使用INDIRECT功能 (Using the INDIRECT Function)

You can use INDIRECT in dependent data validation lists, or to prevent a cell reference from being affected by a move, or create cell references from a combination of cell values and text.

您可以在相关的数据验证列表中使用INDIRECT，或者防止单元格引用受到移动的影响，或者根据单元格值和文本的组合创建单元格引用。

For more information on the INDIRECT function, and examples of how to use it, please visit the INDIRECT Function page on my website. ________________

有关INDIRECT函数的更多信息以及使用方法的示例，请访问我网站上的INDIRECT Function页面。 ________________