Nov 24 2021 01:19 PM
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
Nov 24 2021 01:33 PM
[@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.