Forum Discussion
IF Function #SPILL
I need to use the IF Function for my Excel project, but when i enter everything in exactly how it says to i keep seeing #SPILL. IF([Specialty}="Loans", [Account Values]*0.0025,0) The above formula...
Liv-Landry092100 You can't have dynamic array formula the spill inside a structured table. Use this in stead in H9:
=IF([@Specialty]="Loans", [@[Account Values]]*0.0025,0)
Easily achieved by clicking in the cells on the same row, rather than selecting the entire column.