#DIV/0! "Function DIVIDE parameter 2 cannot be zero" in Google Sheets: blank cells count as zero

<p><code>=A2/B2</code> shows <strong>#DIV/0!</strong> and the tooltip says <em>Function DIVIDE parameter 2 cannot be zero</em>. Often B2 isn't even a zero. It's empty. In arithmetic, Google Sheets treats a blank cell as 0.</p> <h2> Reproduce it in 30 seconds </h2> <div class="table-wrapper-paragraph"><table> <thead> <tr> <th></th> <th>A (qty)</th> <th>B (days)</th> <th>C <code>=A/B</code> </th> </

Read the source →