having trouble with Spill error!

%3CLINGO-SUB%20id%3D%22lingo-sub-1561750%22%20slang%3D%22en-US%22%3Ehaving%20trouble%20with%20Spill%20error!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1561750%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2CI%20am%20a%20beginner.%20I%20am%20learning%20about%20Creating%20Calculated%20Fields%2C%20using%20IF%20function.%3C%2FP%3E%3CP%3EI%20am%20following%20exactly%20Microsoft%20Excel%202019%20instruction%20but%20I%20am%20keep%20getting%20Spill%20error.%3C%2FP%3E%3CP%3EThis%20is%20What%20I%20am%20typing%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%3Dif(%5BSpecialty%5D%3D%22Loans%22%5BAccount%20Values%5D*.0025%2C0)%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1561750%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

Hi everyone,I am a beginner. I am learning about Creating Calculated Fields, using IF function.

I am following exactly Microsoft Excel 2019 instruction but I am keep getting Spill error.

This is What I am typing      =if([Specialty]="Loans"[Account Values]*.0025,0)       

2 Replies
Highlighted

@Fariba_150 , looks like your formula is missing a ",":

=if([Specialty]="Loans",[Account Values]*.0025,0) 

 

Also, this is a Dynamic Array function that will Spill. So it won't work inside Excel Tables if you are trying to write this inside a Table.

Highlighted

@Fariba_150 

Most probably you mean

=IF([@Speciality]="Loans",[@[Account Values]]*0.0025,0)

i.e. formula is for the current row of the table, not for entire column