Forum Discussion
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...
A formula like =6000 -(B2-B8) will most definitely NOT cause a spill error as it does not spill. It's just the same as =6000 - B2 + B8.
However, =6000 -(B2:B8) will spill and could result in an error if there aren't enough blank cells to spill the result into. Is that the formula you are using?