Japanese version. Spill is a feature that was implemented in 2019.This is a very beneficial feature for books with a large amount of formulas. Spill is an updated version of Array formula, and its shortcomings have been eliminated. Comparison of use cases with conventional methods. As an example, we will show you a sample that calculates the amount based on price, quantity and tax rate. Normal Formula. The most common method is to create a formula in one cell and copy it to another cell. Advantages The advantage is that it is an easy and commonly known method. There is nothing wrong with small sheets. Disadvantages When large numbers of … Continue reading Spill. Usage, advantages and disadvantages of Spill. (Dynamic array formulas.)