Results 1 to 7 of 7
  1. #1
    4 Star Lounger
    Join Date
    May 2002
    Location
    US
    Posts
    439
    Thanks
    0
    Thanked 0 Times in 0 Posts

    ISERROR question (2003)

    Greetings,

    I have the following formula. In come cases where one of the cells in the formula being referenced is blank, I get the #value. I think I should be using the ISERROR, but I have tried to no avail.

    It is possible that DE76 and/or HV76 could be blank. I have a few occasions where that is the case. Most often IF I have blanks, it is in DE76. Rarely will the data in HV76 be blank.

    Here is the formula.


    =IF(DE76="",TODAY()-HV76,DE76-HV76+1)



    Thanks,
    Brad

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

    Re: ISERROR question (2003)

    Are you sure that DE76 is really blank when it seems to be so? Your formula shouldn't return #VALUE for real blanks.

  3. #3
    4 Star Lounger
    Join Date
    May 2002
    Location
    US
    Posts
    439
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ISERROR question (2003)

    Hans,
    Looks like this is one of the cases where both referenced cells DE and HV are blank (empty). I realize that calcs can not be performed on empty cells, but I need to report an average of the column where the formulas are, and with a #value in the results, I cannot do the next step for average.

    This is the rare case, and not the norm. Usually, IF I get blanks, it will be in the DE field.


    Brad

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

    Re: ISERROR question (2003)

    Could you attach a small sample workbook with some examples of the error?

  5. #5
    4 Star Lounger
    Join Date
    May 2002
    Location
    US
    Posts
    439
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ISERROR question (2003)

    attached as requested.

    Brad
    Attached Files Attached Files

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

    Re: ISERROR question (2003)

    Ah yes, it is as I suspected: E3 and E4 are *not* blank, they contain a space.
    Moreover, calculation is set to manual, so changing a cell value doesn't result in formulas being recalculated.

  7. #7
    4 Star Lounger
    Join Date
    May 2002
    Location
    US
    Posts
    439
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ISERROR question (2003)

    Will Fix. I had (in the macros) taken care of the first Space, but the second one I had not.

    Had to delete the macros and a bunch of stuff to get it posted.


    Thanks,
    Brad

Posting Permissions

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