shows an image from a url — the browser loads it, the engine does not fetch · from google sheets · excel: differs in detail · sheets: differs in detail

signature

IMAGE(url, [mode], [height], [width])

returns: image

argument	required
url	required
mode	optional
height	optional
width	optional

examples

formula and result, taken from the engine's own test suite — every result below is asserted in CI, not written by hand.

errors

error values observed from the engine — each with a call that produces it.

error	produced by
#VALUE!	=IMAGE(2)

related

• FROMBYTES converts byte array to integer
• GENERATEID generates unique ID with prefix and random suffix
• HASH hex digest of text: SHA256 (default, FIPS 180-4) or MD5 (RFC 1321)
• ISIN checks if value is in a range or comma-separated list
• RANDOMCHOICE random pick from a range (with replacement); count > 1 spills a column
• RANDOMINT.UNIQUE generates unique random integers in range