Mar 31 2021 08:56 AM - edited Mar 31 2021 09:00 AM
@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.