Aug 02 2020 01:27 PM
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)
Aug 02 2020 01:44 PM
@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.
Aug 03 2020 01:17 AM
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