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

3

=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

23.9k8 gold badges42 silver badges69 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