Question: how do you create a structured reference formula in excel?
Answer: Select cell E1, type Bonus, and press Enter. Excel automatically formats the column for you. Select cell E2 and type =0.02*[ A list of structured references (the columns) appears. ...  Close with a square bracket and press Enter. ...  First, select a cell inside the table. ...  Select cell E18 and enter the formula shown below.