IF formula issue not working

%3CLINGO-SUB%20id%3D%22lingo-sub-3003324%22%20slang%3D%22en-US%22%3EIF%20formula%20issue%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3003324%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20get%20an%20assignment%20done%20for%20college%20for%20Module%206%20SAM%20Project.%20The%20formula%20that%20I%20have%20to%20enter%20is%3A%3C%2FP%3E%3CP%3E%3Dif(%5B%40Specialty%5D%3D%22Loans%22%2C0%2C%5B%40%5BAccount%20Values%5D%5D*.0025%2C0)%3C%2FP%3E%3CP%3EI%20have%20used%20the%20define%20names%20tab%2C%20but%20it%20is%20still%20not%20working.%20The%20specialty%20column%20in%20the%20table%20is%20words%20such%20as%20CD%2FMoney%20Market%2C%20Checking%2FSavings%2C%20IRA%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3003324%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3003365%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20formula%20issue%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3003365%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1228999%22%20target%3D%22_blank%22%3E%40sarahshockley4%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%5B%40Specialty%5D%20and%20%5B%40%5BAccount%20Values%5D%5D%20are%20structured%20table%20references%2C%20but%20you%20haven't%20converted%20your%20data%20to%20a%20table.%3C%2FP%3E%0A%3CP%3ESelect%20A8%3AI22%2C%20then%20click%20Table%20on%20the%20Insert%20tab%20of%20the%20ribbon%2C%20and%20click%20OK.%3C%2FP%3E%0A%3CP%3EYou'll%20get%20an%20error%20in%20H9.%20Change%20the%20formula%20in%20that%20cell%20to%3C%2FP%3E%0A%3CP%3E%3DIF(%5B%40Specialty%5D%3D%22Loans%22%2C%5B%40%5BAccount%20Values%5D%5D*0.0025%2C0)%3C%2FP%3E%0A%3CP%3EAnd%20in%20I9%3A%3C%2FP%3E%0A%3CP%3E%3DIF(%5B%40Specialty%5D%3D%22Loans%22%2C0%2C%5B%40%5BAccount%20Values%5D%5D*0.0025)%3C%2FP%3E%0A%3CP%3ENote%20that%20there%20is%20no%20%2C0%20at%20the%20end%20in%20this%20formula.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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

1 Reply

@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.