#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 formula under the New Money Commission

=if([Specialty]="Loans",0,[Account Values]*0.0002)

I enter both of them in and the #Spill! the error came up twice. Before I insert the formulas I check and see if the range was empty of any data and it was but still the error came up. I've been trying to figure out how to get the error away so I can finish my assignment for the past couple of hours.

Please give me suggestions, solutions, anything to fix this.

Thanks for the help

excel

Formulas and Functions

wumolad
Steel 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.
- jb0y1e7
  Copper Contributor
  Apr 25, 2020
  wumolad
  SC_EX_6_BankAccountManagers.xlsx26 KB
  - PeterBartholomew1
    Silver Contributor
    Apr 23, 2021
    jb0y1e7
    The formulas are valid provided they are not entered within a table.
    SC_EX_6_BankAccountManagers(PB).xlsx24 KB

Forum Discussion

#Spill! EXCEL

Share

Resources