Results 1 to 3 of 3

Thread: #div/!

  1. #1
    Join Date
    Mar 2004
    Location
    California
    Posts
    502

    Unanswered: #div/!

    I have two columns that have simple formulas. The data in this worksheet changes once a month.

    If one of the fields used in the formula calculations has a 0 (zero) the I receive the terribly despicable #DIV/! error.

    I want to replace that with word "Null" without disturbing any formulas.

    I've look here but could not find a solution that worked.

    Even the built-in search & replace function failed.

    All of my data are either numbers, currency, and some percent numbers.

    I tried some of the suggestions here and on the Internet but they (or me!) failed in the attempts.

    I've also tried the If, Then, Else suggestion without success.

    Can't it be something simple?

    Thanks . . . Rick

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    I was able to avoid the #DIV/! error with the following IF statement in cell B1:
    Code:
    =IF(A1=0,"null", 10/A1)
    with the value in A1 being 0, of course. Is the problem more that you are dealing with formulas that consume other formulas?

  3. #3
    Join Date
    Jul 2015
    Posts
    2
    have you tried using =IF(ISERROR(YOUR FORMUMA),0,YOUR FORMULA)

Posting Permissions

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