Inserts an image into a cell.
Important: You can only use URLs that aren't hosted at drive.google.com. SVG file format isn't supported.
Volatility restrictions: You cannot directly or indirectly reference a volatile function in the base URL, the consistent part of the website's address, of the IMAGE function.
-
NOW(), RAND(), RANDARRAY(), RANDBETWEEN()
are examples of volatile functions.
Sample usage
IMAGE('https://www.google.com/images/srpr/logo3w.png')
IMAGE(A2,2)
IMAGE(A2,4,120,200)
Syntax
IMAGE(url, [mode], [height], [width])
-
url
– The URL of the image, including protocol (e.g.http://
).- The value for
url
must either be enclosed in quotation marks or be a reference to a cell containing the appropriate text.
- The value for
-
mode
– [ OPTIONAL –1
by default ] – The sizing mode for the image-
1
resizes the image to fit inside the cell, maintaining aspect ratio. -
2
stretches or compresses the image to fit inside the cell, ignoring aspect ratio. -
3
leaves the image at original size, which may cause cropping. -
4
allows the specification of a custom size. -
Note that no mode causes the cell to be resized to fit the image.
-
-
height
– [ OPTIONAL ] – The height of the image in pixels.mode
must be set to4
in order to set a custom height. -
width
– [ OPTIONAL ] – The width of the image in pixels.mode
must be set to4
in order to set a custom width.
Examples
Inserts an image inside a cell.