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 ?
michaellajakala You still didn't give me the exact formula, so I'm going to try and reconstruct it from your latest response.
=IF(OR([Store]="Bonham",[Store]="Graham"),[Current Salary]*0.035,[Current Salary]*0.025)This will look at the entire column "Store" and spills the results as a dynamic range. But when you enter the formula in the table, it copies itself down the entire column. Thereby, blocking its own spill range.
Try it this way:
=IF(OR([@Store]="Bonham",[@Store]="Graham"),[@[Current Salary]]*0.035,[@[Current Salary]]*0.025)Note the ampersands in front of each of the column names. They will appear in the formula as you build it by pointing at the cells.