Forum Discussion
IF formula issue not working
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...
.png){kind=link}
[@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.