Forum Discussion
having trouble with Spill error!
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 Wh...
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.