Assuming the value in A1 is 1, then the formula to use in B1 is;
=IF(A1=1,HYPERLINK("http:\\www.microsoft.com","www .microsoft.com"),"")


"clemson1994" wrote:


This is driving me nuts. There has to be a simple solution to this.
Somebody help me!

I want Excel to examine the contents of a cell (say "A1" and do one of
two things in cell "B1":

1. If "A1" contains a certain value, I want Excel to display a
hyperlink to a web site in "B1".

2. If "A1" does not contain this value, I want Excel to display
nothing at all in "B1".

Surely this is possible (and probably easy). Right??


--
clemson1994
------------------------------------------------------------------------
clemson1994's Profile: http://www.excelforum.com/member.php...o&userid=28225
View this thread: http://www.excelforum.com/showthread...hreadid=477762