Microsoft KB Archive/20024

ISREF function will not return FALSE PSS ID Number: Q20024 Article last modified on 03-18-1987 PSS database name: D_MPlan

MS-DOS

Problem: ISREF is supposed to return FALSE if the name is not defined in the spreadsheet. Instead, it returns #NAME!.

Response: Here is a workaround that you can use. Suppose you wanted to check to see if you had a cell or range of cells named “Fred”. If ISREF were working you would type ISREF(FRED). To get it to work properly, you have to enter NOT(ISERROR(ISREF(FRED))).

Copyright Microsoft Corporation 1987.