IF Function #SPILL

Question

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.

Spoiler

riny_van_eekelen · Answer

Liv-Landry092100&nbsp;You can't have dynamic array formula the spill inside a structured table. Use this in stead in H9:&nbsp;=IF([@Specialty]="Loans", [@[Account Values]]*0.0025,0)&nbsp;Easily achieved by clicking in the cells on the same row, rather than selecting the entire column.&nbsp;

Forum Discussion

IF Function #SPILL

1 Reply

Resources