News, tips, advice, support for Windows, Office, PCs & more. Tech help. No bull. We're community supported by donations from our Plus Members, and proud of it
Home icon Home icon Home icon Email icon RSS icon
  • Formula Help for Google Sheets

    Viewing 1 reply thread
    • Author
      Posts
      • #2264755 Reply
        WSJon5
        AskWoody Lounger

        Hi all,

        I suspect the solution to this question is simple, but I can’t figure it out:

        Here’s the formula I’m using in a Google Sheet:

        =sum(C3/B3)

        The problem is, if C3 and B3 are both 0, then the formula produces an error:

        #DIV/0!

        Scrolling over the cell brings up this explanation:

        “Function DIVIDE parameter 2 cannot be zero.”

        Is it possible, if the sum is zero, for the cell to display 0 instead of an error?

        Thanks so much!

      • #2264799 Reply
        Paul T
        AskWoody MVP

        =iferror(sum(C3/B3),0)

        cheers, Paul

        1 user thanked author for this post.
    Viewing 1 reply thread

    Please follow the -Lounge Rules- no personal attacks, no swearing, and politics/religion are relegated to the Rants forum.

    Reply To: Formula Help for Google Sheets

    You can use BBCodes to format your content.
    Your account can't use Advanced BBCodes, they will be stripped before saving.