Thread: Showing/Hiding a mailto hyperlink based on a cell value

Hi,

Hope you can help.

I need to be able to show a mailto link if the cell value in A1 is specific text for example 'Test Positive'. WIthin the hyperlink contents of other cells need to be shown. The later part I have managed the code is below:

=HYPERLINK("mailto:joe@bloggs.com?subject="&SUBSTITUTE("Completed Testing Item: "&$J6," ","%20")&"&body=Testing Item Ref Number: "&$H6,"Send Email to Testing")

But I only want this mailto shown if the value in cell A1 is 'Test positive' else hide it. Is this possible?

THANK YOU

=IF(A1="hide link",HYPERLINK("http://www.excelforum.com/showthread.php?t=648753"),"") works for me

Thank you that worked brilliantly