Spill Error with structured reference and table.

I am following along with an assignment in Office basics clas and I (and a few fellow students) ran into an error where we got a SPILL error instead of having the formula executed correctly. The assignment has already been graded, but I want to know what I did wrong. In the end I converted my table to a range and then back again to circumvent the problem, but that wasn't the expected way to do it.

The Instructions are:

1. Click cell H9 to select it. Click the ‘Accounting Number Format’ button (Home tab | Number group) so that data in the selected column is displayed as a dollar amount with two decimal places.
2. Type =if([ to display the list of available fields in the table (Figure 6–20).
3. Double-click Specialty to select the field to use for the IF function.
4. Type ]=“Loans”, [Account Values] *.0025, 0) to complete the structured reference and then click the Enter button to create the calculated column

I know it looks like it could be sensitive data, but it's demo data from said assignment.

Thank you.

Welcome to the forum.

The structured reference was to column when it should be to cell.
Also, the quotation marks were some wrong characters.
Try this:
=IF([@Specialty]="Loans", [@[Account Values]]*0.0025, 0)

Good luck!