S
Søren Voigt
I have a list of customer names in column F and links to their websites eg. 'www.abc.com in column H. I intend to produce a list of customers which when the link to their website is known is a hyperlink and when the link is unknown just shows the customer name as plain text.
I use the formula:
=IF(H3="";F3;HYPERLINK(H3;F3))
However, even when the IF-statement is TRUE the output-cell is formatted as a hyperlink with an empty string as the link.
How can I make the output format as a hyperlink only when the IF-statement is FALSE and a hyperlink is in the cell.
Thanks in advance
Søren
I use the formula:
=IF(H3="";F3;HYPERLINK(H3;F3))
However, even when the IF-statement is TRUE the output-cell is formatted as a hyperlink with an empty string as the link.
How can I make the output format as a hyperlink only when the IF-statement is FALSE and a hyperlink is in the cell.
Thanks in advance
Søren