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"))

2 Answers 2


     IMAGE("https://i.stack.imgur.com/XJ2AY.png"; 3))


demo spreadsheet

  • 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 Apr 4, 2019 at 8:44
  • Hi i tried the demo but the hyperlink doesn't work . Any idea ?
    – andio
    Sep 26, 2019 at 12:32

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


  • 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? Apr 4, 2019 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 Apr 4, 2019 at 8:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.