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?

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

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.