INDIRECT function - Microsoft Support
How to use the INDIRECT function in Excel to change the reference to a cell within a formula without changing the formula itself.
INDIRECT function - Microsoft Support
How to use the INDIRECT function in Excel to change the reference to a cell within a formula without changing the formula itself.
Lookup and reference functions (reference) - Microsoft Support
Excel comes with multiple Lookup and Reference functions that let you find matching values. Use this article to decide which function is best for your needs.
Excel functions that return ranges or arrays - Microsoft Support
In September, 2018 we announced that Dynamic Array support would be coming to Excel. This allows formulas to spill across multiple cells if the formula returns multi-cell ranges or arrays. This new …
Excel functions (by category) - Microsoft Support
Lists all Excel functions by their category, such as Logical functions or Text functions.
Excel functions that return ranges or arrays - Microsoft Support
In September, 2018 we announced that Dynamic Array support would be coming to Excel. This allows formulas to spill across multiple cells if the formula returns multi-cell ranges or arrays. This new …
Formulas and functions - Microsoft Support
Learn these top skills to create your own formulas and functions.
Evaluate a nested formula one step at a time - Microsoft Support
With the Evaluate Formula dialog box, you can see how a nested formula calculates its result by inspecting its intermediate calculations and logical tests.
Create a 3-D reference to the same cell range on multiple worksheets
You can use a 3-D reference to add up budget allocations between three departments, Sales, HR, and Marketing, each on a different worksheet, by using the following 3-D reference: =SUM …
Implicit intersection operator: @ - Microsoft Support
Dynamic arrays bring significant new calculation ability and functionality to Excel. Excel's upgraded formula language is almost identical to the old language, except that it uses the @ operator to …
INDIRECT 函数 - Microsoft 支持
如何在 Excel 中使用 INDIRECT 函数在不更改公式本身的情况下更改对公式中的单元格的引用。