IF formula issue not working

[sarahshockley4]

I am trying to get an assignment done for college for Module 6 SAM Project. The formula that I have to enter is:

=if([@Specialty]="Loans",0,[@[Account Values]]*.0025,0)

I have used the define names tab, but it is still not working. The specialty column in the table is words such as CD/Money Market, Checking/Savings, IRA

[#2]

@sarahshockley4 

[@Specialty] and [@[Account Values]] are structured table references, but you haven't converted your data to a table.

Select A8:I22, then click Table on the Insert tab of the ribbon, and click OK.

You'll get an error in H9. Change the formula in that cell to

=IF([@Specialty]="Loans",[@[Account Values]]*0.0025,0)

And in I9:

=IF([@Specialty]="Loans",0,[@[Account Values]]*0.0025)

Note that there is no ,0 at the end in this formula.