Forum Discussion
Spill error with IF function
When i added the following data, =IF([Specialty]="Loans",[Account Values]*0.0025,0) I keep getting a Spill error and I am unsure why. I was following my professors steps and for her it works fine.
.png){kind=link}
Johann_six You can't use dynamic array formulae inside a structured table.
Try it this way:
=IF([@Specialty]="Loans",[@Account Values]*0.0025,0)
It will calculate the Commission row-by-row in stead of trying to spill an array.