Results 1 to 2 of 2

Thread: #DIV/0! (2002)

  1. #1
    3 Star Lounger
    Join Date
    Mar 2004
    Location
    North Carolina, USA
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    #DIV/0! (2002)

    Is there a formula that will keep this from displaying and display a blank? For example if my original formula is =i9/d9 is there something I can add to it to keep this from happening?

    Mitch

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: #DIV/0! (2002)

    For this specific example
    <code>
    =IF(D9=0,"",I9/D9)
    </code>
    Or, more generic
    <code>
    =IF(ISERROR(I9/D9),"",I9/D9)
    </code>
    In the latter example, you can replace I9/D9 with any expression that might result in an error.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •