Forum Discussion

Fariba_150's avatar
Fariba_150
Copper Contributor
Aug 02, 2020

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 What I am typing      =if([Specialty]="Loans"[Account Values]*.0025,0)       

excel

2 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Aug 03, 2020

    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

  • TheAntony's avatar
    TheAntony
    Iron Contributor
    Aug 02, 2020

    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.

Resources