Thread: Conditional Hyperlink (If statement?)
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Oreg[_49_] Oreg[_49_] is offline
external usenet poster
  
Posts: 1
Default Conditional Hyperlink (If statement?)

Hi clemson1994,

Try entering the function below into cell B1. If the value in A1 is 1,
then the URL address should appear in B1. You can manipulate the A1=1
to whatever value you are interested in.


=IF(A1=1,HYPERLINK("http://www.yahoo.com"),"")

Hope this helps you !

Oreg


--
Oreg
------------------------------------------------------------------------
Oreg's Profile: http://www.excelforum.com/member.php...fo&userid=9195
View this thread: http://www.excelforum.com/showthread...hreadid=477762

Reply With QuoteReply With Quote