ID: Q156926
The information in this article applies to:
In Microsoft Excel 97, if a formula in a cell contains the HYPERLINK worksheet function, the following behavior may occur:
-and-
-and-
This problem occurs if you nest the HYPERLINK function in an IF function. For example, the problem occurs when you type the following formula into a cell:
=IF(A1<10,HYPERLINK("http://msnbc.com","Welcome to MSNBC!"),
"No link!")
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.
In Microsoft Excel 97, the HYPERLINK worksheet function allows you to create a hyperlink to a World Wide Web page or other Internet resource. The function accepts two arguments, a reference to a location, that is, either a Uniform Resource Locator (URL) or a document name; and the text string that appears in the cell.
For more information about the HYPERLINK function, click the Index tab in Microsoft Excel Help, type the following text
hyperlink
and then double-click the selected text to go to the "HYPERLINK"
topic.
Additional query words: XL97 explorer netscape www ftp 8.0
Keywords : kbdta xlformula
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbprb
Last Reviewed: May 19, 1999