| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Hyperlink (If statement?)
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Conditional Hyperlink (If statement?)
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Conditional Hyperlink (If statement?)
Oreg Wrote: 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 Yes, but how do I have the website come up as a hyperlink. When I did what you suggested, it just displayed the url. Can't click on it. -- clemson1994 ------------------------------------------------------------------------ clemson1994's Profile: http://www.excelforum.com/member.php...o&userid=28225 View this thread: http://www.excelforum.com/showthread...hreadid=477762 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Conditional Hyperlink (If statement?)
Shoot, my apologies, it does work!!! Nevermind! I was expecting it to show up blue with an underline. Thankyou -- clemson1994 ------------------------------------------------------------------------ clemson1994's Profile: http://www.excelforum.com/member.php...o&userid=28225 View this thread: http://www.excelforum.com/showthread...hreadid=477762 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Conditional Hyperlink (If statement?)
No problem, I've asked so many questions in this forum, I've been bursting for the opportunity to help someone out !!! I know so little, the opportunity is rare !!! :) Take it easy 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hyperlink in an IF statement | Excel Worksheet Functions | |||
| Hyperlink in an IF statement. | Excel Worksheet Functions | |||
| Conditional hyperlink? | Excel Discussion (Misc queries) | |||
| How can I use HYPERLINK in a conditional statement between sheets | Excel Worksheet Functions | |||
| Conditional Hyperlink? | Excel Programming | |||
Hybrid Mode
