Forum Discussion

jb0y1e7's avatar
jb0y1e7
Copper Contributor
Apr 25, 2020

#Spill! EXCEL

  I'm working on a project for my Data Analytics class for college. I have to insert a formula  under the Loan Commission    =if([Specialty]="Loans",[Account Values]*0.0025,0)   and another for...
excel
Formulas and Functions
wumolad's avatar
wumolad
Iron Contributor
Apr 25, 2020

jb0y1e7 is it possible to send an excel file so we can trace the error together.

 

#SPILL errors are returned when a formula returns multiple results, and Excel cannot return the results to the grid.

      • bdavid10's avatar
        bdavid10
        Copper Contributor
        Apr 23, 2021
        Thank you so much!
    • wumolad's avatar
      wumolad
      Iron Contributor
      Apr 26, 2020

      Hi jb0y1e7 

       

      As Detlef_Lewin pointed out, you only need to refer to a cell and the formula is copied to other cells rather than referring to the whole column. Also, you do not need to use an array formula.

       

      I have attached the updated file.

       

      Cheers.

      • Paper_Queen's avatar
        Paper_Queen
        Copper Contributor
        Mar 22, 2021

        wumoladYou have no idea how helpful this is, I have been trying to complete an assignment with this specific formula for days now, and I haven't been able to figure it out. Thank you so much for explaining this!

    • Detlef_Lewin's avatar
      Detlef_Lewin
      Silver Contributor
      Apr 26, 2020

      jb0y1e7 

      You formula refers to a whole column instead of a single cell:

      =if([@Specialty]="Loans",[@[Account Values]]*0.0025,0)
      • bdavid10's avatar
        bdavid10
        Copper Contributor
        Apr 23, 2021

        Detlef_Lewin I am having the same problem with the #spill error for the formula using 0.0002, could you please help me out here?

Resources