IF Function #SPILL

%3CLINGO-SUB%20id%3D%22lingo-sub-2247144%22%20slang%3D%22en-US%22%3EIF%20Function%20%23SPILL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2247144%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20use%20the%20IF%20Function%20for%20my%20Excel%20project%2C%20but%20when%20i%20enter%20everything%20in%20exactly%20how%20it%20says%20to%20i%20keep%20seeing%20%23SPILL.%26nbsp%3B%3C%2FP%3E%3CP%3EIF(%5BSpecialty%7D%3D%22Loans%22%2C%20%5BAccount%20Values%5D*0.0025%2C0)%3C%2FP%3E%3CP%3EThe%20above%20formula%20is%20what%20I%20am%20having%20issues%20with.%3C%2FP%3E%3CDIV%20class%3D%22lia-spoiler-container%22%3E%3CA%20class%3D%22lia-spoiler-link%22%20href%3D%22%23%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%20target%3D%22_blank%22%3ESpoiler%3C%2FA%3E%3CNOSCRIPT%3E(Highlight%20to%20read)%3C%2FNOSCRIPT%3E%3CDIV%20class%3D%22lia-spoiler-border%22%3E%3CDIV%20class%3D%22lia-spoiler-content%22%3E%3CDIV%20class%3D%22lia-spoiler-container%22%3E%3CA%20class%3D%22lia-spoiler-link%22%20href%3D%22%23%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%20target%3D%22_blank%22%3ESpoiler%3C%2FA%3E%3CNOSCRIPT%3E(Highlight%20to%20read)%3C%2FNOSCRIPT%3E%3CDIV%20class%3D%22lia-spoiler-border%22%3E%3CDIV%20class%3D%22lia-spoiler-content%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%20%3C%2FDIV%3E%3CNOSCRIPT%3E%3CDIV%20class%3D%22lia-spoiler-noscript-container%22%3E%3CDIV%20class%3D%22lia-spoiler-noscript-content%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FNOSCRIPT%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2247144%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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.

Spoiler
Spoiler
 

 

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.