Forum Discussion
#SPILL! ERROR
I am setting up a grade book and trying to get the sheet to convert numbers within a certain range (the letter grade column below) to a Letter grade, but I am getting the #SPILL! error. Any idea how ...
#Spill! means that the formula is trying to give you a result that spans multiple cells. for instance. the formula '=A1:D5' would return a table of the values in the range A1:D5. this would require that the formula be in the top left corner of a range 4Colums wide by 5 rows. in short. the formula is trying to return a range larger than the space available.
JagodragonThank you! What should I do to ensure I do not encounter this error?
- You just need to ensure that your formula will have the space required. Clear out the cells to the right and bellow to enable the expansion that could happen in the future.
Sorry there's no answer that is a perfect fix all...