Question: how to create a formula with structured references excel?
Answer: Type an asterisk (*) directly after the closing bracket, and click cell D2. In the formula bar, the structured reference [@[% Commission]] appears after the asterisk. Press Enter. Excel automatically creates a calculated column and copies the formula down the entire column for you, adjusting it for each row.