formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-1302919%22%20slang%3D%22en-US%22%3Eformulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1302919%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20I%20am%20trying%20to%20complete%20an%20assignment%20on%20my%20IT%20lab%2Cand%20when%20I%20insert%20a%20function%20it%20says%20spill.%20I%20need%20help%20on%20how%20to%20resolve%20this%20issue%2Cplease%20and%20thankyou%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1302919%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1302954%22%20slang%3D%22en-US%22%3ERe%3A%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1302954%22%20slang%3D%22en-US%22%3ESpill%20error%20is%20occasioned%20by%20something%20that's%20blocking%20the%20spill%20range.%20For%20example%20if%20your%20spill%20range%20is%20A1%3AA10%20and%20there%20is%20a%20value%20in%20cell%20A4%20or%20any%20other%20cells%20within%20A1%3AA10%2C%20you%20will%20get%20spill%20error...%20All%20you%20need%20to%20do%20is%20to%20remove%20the%20value%20within%20the%20spill%20range%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hello I am trying to complete an assignment on my IT lab,and when I insert a function it says spill. I need help on how to resolve this issue,please and thankyou

2 Replies
Highlighted
Spill error is occasioned by something that's blocking the spill range. For example if your spill range is A1:A10 and there is a value in cell A4 or any other cells within A1:A10, you will get spill error... All you need to do is to remove the value within the spill range
Highlighted

@samantha305 

 

Some functions--you don't say which you were using--deliver results in the form of multiple rows of data, in an array; doing so is referred to as a "Spill"

 

You need to provide room for that to happen.

 

If that doesn't make sense, come back with a more complete description, including the name of the Function you're attempting to use. If possible, include a posting of your actual spreadsheet.