Forum Discussion

stevia13's avatar
stevia13
Copper Contributor
Mar 26, 2026
Solved

SPILL error

Hi. I'm just using a very simple formula to calculate how much money is still due from an original total amount. The formula I have typed is simply in this format: 6000 -(B2-B8), but in the next agai...
excel
  • Olufemi7's avatar
    Olufemi7
    Mar 26, 2026

    Hello stevia13​,

    The SPILL happens because B2-B8 is treated as a range, which creates multiple results. Use =6000 - SUM(B2:B8) to get a single value and stop the SPILL. Make sure the cells below are empty.

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Mar 28, 2026

Could you please give bit more details or at least screenshot.

  • you have some formula (=6000 -(B2-B8) ) in the cell
  • in NEXT (again?) cell you have #SPILL! error. If so, it doesn't matter what is in first cell, more important what is in this (next) one
  • below (below next?) number 6000 (as number of cells) is displaying. How exactly do you show number of cells?