XL97: HYPERLINK Doesn't Work If Second Argument Returns Error

   =HYPERLINK("http://msnbc.com",A1/B1)
				

   =HYPERLINK("http://msnbc.com",IF(B1=0,0,A1/B1))
				

MORE INFORMATION

In Microsoft Excel 97, the HYPERLINK worksheet function allows you to create a hyperlink within a worksheet cell. The HYPERLINK function accepts two arguments:

   Argument        Description
   -------------------------------------------------------------------

   link_location   the path and file name, or URL, you want to link to
   friendly_name   the text that should appear in the cell
				

The friendly_name argument can be a text string, a defined name, or any other expression that returns a value.

If the value of the friendly_name argument returns an error value, the hyperlink will not work when you click it. Here are some example formulas that demonstrate this problem.

Example 1: #VALUE! error

This hyperlink will fail because the expression 1+"Alpha" returns a #VALUE! error:

   =HYPERLINK("http://msnbc.com",1+"Alpha")
				

Example 2: #NAME? error

This hyperlink will fail if the defined name "Bravo" doesn't exist, because it results in a #NAME? error:

   =HYPERLINK("http://msnbc.com",Bravo)
				

Example 3: #DIV/0! error

This hyperlink will fail if the mathematical expression returns any type of error, such as #DIV/0!:

   =HYPERLINK("http://msnbc.com",A1/B1)