Mar 31 2021 08:16 AM
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.
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.
