This tutorial will show you how to use structured references in Excel.
Join the channel Telegram of the AnonyViet 👉 Link 👈 |
Structured References
When working with tables in Excel, you can use structured references to make your formulas easier to understand.
1. Select cell E1, type Bonus and press Enter. Excel automatically formats the column for you.
2. Select cell E2 and enter =0.02*[[
3. A list of structured references (columns) will appear. Select Sales from the list.
4. Close with square brackets and press Enter.
Result. Excel will automatically copy the formula down the column for you.
Note: click TAutoCorrect Options and click Undo Calculated Column to insert the formula only in cell E2.
To refer to this table in a formula, do the following:
5. First, select a cell within the table. Next, on the Design tab, we can see Table1 as the name of this table.
6.Select cell E18 and enter the formula shown below.
In addition, you can also view many other excel articles here.