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...
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.
