30 June, 2016

Creating conditional hyperlinks in MS Excel

In cell 'B2'...

=IF(A2="goodbye",HYPERLINK("https://www.google.com/search?q="&A1,"Search Google for: "&A1),"")

Note: that last ~,""~ {comma double quote double quote}, provides the 'IF' statement with instructions on what to do if the argument returns a 'FALSE' - In the above case, just a blank cell.

If that part is left off, and the argument is 'FALSE', then the cell will contain 'FALSE', but you can put anything you want in there...

Some other text (between those quote-marks), or even a different HYPERLINK:

=IF(A2="goodbye",HYPERLINK("https://www.google.com/search?q="&A1,"Search Google for: "&A1),HYPERLINK("https://www.google.com/search?q="&A2,"Search Google for: "&A2))

No comments:

Post a Comment