Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    102

    Unanswered: Comparing #Ref! value

    In an Excel sheet cell, what is the formula to compare a value to the '#Ref!' or '#Name?' values ?


    For instance, for the forumla:
    =IF(C8=#Ref!,0,E8/C8)

    what would be the correct syntax?

  2. #2
    Join Date
    Apr 2004
    Location
    Derbyshire, UK
    Posts
    789
    Provided Answers: 1
    Hi

    There are a couple of of 'ISEROR' functons but perhaps the one you want is

    =ERROR.TYPE(C8)

    This function returns a number depending on the error.
    However, if there is no error this function returns an error, so it will need an if statment to check that there is an error !!??

    Try searching in Excel help


    MTB
    Last edited by MikeTheBike; 06-26-08 at 09:21.

  3. #3
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    995
    Provided Answers: 2
    I have a suite of forms that pull data through to a printable sheet from a data entry sheet that rather heavily use:
    =IF(ISERROR([OtherFunction]),"",[OtherFunction])
    where [OtherFunction] is frequently a VLOOKUP call to translate user input into computer input.

Posting Permissions

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