Can I set a button in google sheets to alter the image url-CodePudding

This feels like it should be dead simple but I've not tried anything like this in google sheets before.

I have an image on a sheet but I want it to change to another image (either via altering the image url, or just hiding one and showing another etc) either via clicking the images themselves or just via a button but have no idea where to start with this and all my googling has ironically, turned up absolutely nothing.

Any help or pointers to useful sources would be greatly appreciated!

CodePudding user response：

insert checkbox:

try:

=IF(A1; IMAGE("https://i.stack.imgur.com/futhU.png"); 
        IMAGE("https://i.stack.imgur.com/JKel8.png"))

or:

=IMAGE("https://i.stack.imgur.com/"&IF(A1; "futhU"; "JKel8")&".png")