IF Function #SPILL

Occasional Visitor

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 is what I am having issues with.



1 Reply

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