Forum Discussion
Error "SPILL"
As you can see in column M, all of my values is inserted "Spill". I used the insert function and added my functions and once I clicked OK, It showed "Spill" in every row. How should I fix this proble...
There is nothing that is in the way to cause “Spill” This is the exact questions I’m having trouble with.
1. Click IF in the Select a function box, and then click the Function Arguments dialog box opens.
2. In the Logical_test box, type OR([Store]=“Bonham”,[Store]=“Graham”) to enter the OR function with structured references.
3. In the Value_if_truealue_if_true box, type [Current Salary]*0.035 and then press the Tab key.
4. In the VValue_if_false box, type [Current Salary]*0.025.
After I press okay all the rows are saying spill.
What should I do to fix the Spill error ?
1. Click IF in the Select a function box, and then click the Function Arguments dialog box opens.
2. In the Logical_test box, type OR([Store]=“Bonham”,[Store]=“Graham”) to enter the OR function with structured references.
3. In the Value_if_truealue_if_true box, type [Current Salary]*0.035 and then press the Tab key.
4. In the VValue_if_false box, type [Current Salary]*0.025.
After I press okay all the rows are saying spill.
What should I do to fix the Spill error ?
if you have multiple instances of :
. In the Logical_test box, type OR([Store]=“Bonham”,[Store]=“Graham”) to enter
in the excel formatted table, you're going to get a spill error.
excel formatted tables do not support array formulas all you're going to get is a #Spill error
try converting the table into a range.
cheers