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)
@Fariba_150 , looks like your formula is missing a ",":
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.
Most probably you mean
i.e. formula is for the current row of the table, not for entire column