---
title: "Discussion on \"#DIV/0! \"Function DIVIDE parameter 2 cannot be zero\" in Google Sheets: blank cells count as zero\" | Hashnode"
description: "Discussion on \"#DIV/0! \"Function DIVIDE parameter 2 cannot be zero\" in Google Sheets: blank cells count as zero\". =A2/B2 shows #DIV/0! and the tooltip says Function DIVIDE parameter 2 cannot be zero. Often B2 isn't even a zero. It's empty. In arithmetic, Google Sheets treats a blank cell as 0.\nReproduce it in 30"
url: "https://hashnode.com/posts/div-0-function-divide-parameter-2-cannot-be-zero-in-google-sheets-blank-cells-count-as-zero/6aeaa384ef5fa3c93731950b"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [#DIV/0! "Function DIVIDE parameter 2 cannot be zero" in Google Sheets: blank cells count as zero](https://sheeterror.hashnode.dev/div-0-function-divide-parameter-2-cannot-be-zero-in-google-sheets-blank-cells-count-as-zero?utm_source=hashnode&utm_medium=feed)

\=A2/B2 shows #DIV/0! and the tooltip says Function DIVIDE parameter 2 cannot be zero. Often B2 isn't even a zero. It's empty. In arithmetic, Google Sheets treats a blank cell as 0. Reproduce it in 30

Nov 4 · 2 min read · sheeterror.hashnode.dev  
Read the article

-   [#google-sheets](https://hashnode.com/tag/google-sheets)
-   [#spreadsheets](https://hashnode.com/tag/spreadsheets)
-   [#productivity](https://hashnode.com/tag/productivity)
-   [#tutorial](https://hashnode.com/tag/tutorial)

## Written by

[SheetError](https://hashnode.com/@sheeterror)

@sheeterror

  
[View profile](https://hashnode.com/@sheeterror)

Plain-English fixes for Google Sheets and Excel errors. Guides at sheeterror.com

Plain-English fixes for Google Sheets and Excel errors. Guides at sheeterror.com

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
