having trouble with Spill error!

Copper Contributor

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

@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.

@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