Image in a cell with a hyperlink

Question

I need a cell that contains an image to also contain a hyperlink.

Following formula is the only one I found but doesn't work (error analyzing formula)

=HYPERLINK("URL", image("URL"))

Following formula I tried shows a blank cell but the link works

=hyperlink("URL"; Image("URL"))

user0 · Accepted Answer · 2019-04-04 08:31:42Z

1

=HYPERLINK("https://mail.google.com/mail/u/0/";
     IMAGE("https://i.stack.imgur.com/XJ2AY.png"; 3))

answered Apr 4 '19 at 8:31

user0

22.6k8 gold badges37 silver badges64 bronze badges

I found out that the problem was only with the image link. It was from Google Drive and the share link wasn't usable for this. So as you commented, this formula works just fine. Thank you – Marek Marhoul Apr 4 '19 at 8:44
Hi i tried the demo but the hyperlink doesn't work . Any idea ? – andio Sep 26 '19 at 12:32

Add a comment |

Tran Situ · Accepted Answer · 2019-04-04 08:10:20Z

3

Your first formula worked for me. Perhaps there's something off about the way you've formatted one of the URL's?

answered Apr 4 '19 at 8:10

Tran Situ

1313 bronze badges

I am from EU and from what I have seen there are some slight differences between EU and other syntaxes, maybe that might be the reason? – Marek Marhoul Apr 4 '19 at 8:13
yep, you are right. It was actually the difference between EU syntax and the rest of the world. We use a semicolon instead of a comma and it was the image link that wasn't working for this use – Marek Marhoul Apr 4 '19 at 8:52

Add a comment |

2 Answers 2