Microsoft KB Archive/70219

{| = Result of ISNUMBER Displayed Incorrectly in the Formula Bar =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q70219

SUMMARY
If you highlight the formula ISNUMBER(value) in the formula bar and choose Calculate Now (F9), FALSE will be displayed when &quot;value&quot; is an external reference to a closed worksheet, regardless of whether the argument &quot;value&quot; refers to a number, to a blank cell, or to a cell containing text.

MORE INFORMATION
This information refers only to Excel 3.00. Versions earlier than 3.00 do not allow you to use the IS functions with external references to closed documents.

ISNUMBER will be calculated correctly if the underlying worksheet is open.

Example
 Place a &quot;10&quot; (without the quotation marks) in cell A1 of SHEET1.XLS. Close SHEET1.XLS.  Enter the following into cell A1 of SHEET2.XLS: =IF(ISNUMBER('C:\EXCEL\SHEET1.XLS'!$A$1),1,0) NOTE: Modify this path to indicate the location of SHEET1.XLS.  Press ENTER. Cell A1 will contain the value 1 that is correct. Place your cursor in cell A1 of SHEET2.XLS and press F2.  Highlight the following: ISNUMBER('C:\EXCEL\SHEET1.XLS'!$A$1)  Choose Calculate Now (F9).</li> FALSE will be displayed in place of the function ISNUMBER(value). This is incorrect. The result of the ISNUMBER function is TRUE.</li></ol>

Microsoft is researching this problem and will post new information here as it becomes available.