Question: how to create a structured formula in excel?
Answer: To create the table, select any cell within the data range, and press Ctrl+T. Make sure the My table has headers box is checked, and click OK. In cell E2, type an equal sign (=), and click cell C2. In the formula bar, the structured reference [@[Sales Amount]] appears after the equal sign.