IMAGE Function

Description

Checks whether the input argument in a Lambda function is missing and returns TRUE or FALSE.  

NOTE

• The returned data type is compound data, images are in cells so you can use sort and filter, calculate, and write formulas with pictures, move or resize the cells.
• Supported file formats: BMP, JPG/JPEG, GIF, TIFF, PNG, ICO, and also WEBP (WEBP is unsupported on Web and Android).
• Common error:
  – If there are issues with your internet connection or the server providing the source, function returns a #CONNECT! error.
  – Make sure Linked Data Type is enabled. If not, the security settings block access to the image, function returns a #BLOCKED! error.

Syntax

Copied!=IMAGE(url, [alt_text], [sizing], [height], [width])
=IMAGE(url, [alt_text], [sizing], [height], [width])

EXAMPLE

Copied!//[𝘰𝘱𝘵𝘪𝘰𝘯𝘢𝘭]: 𝘢𝘭𝘵_𝘵𝘦𝘹𝘵="", 𝘴𝘪𝘻𝘪𝘯𝘨=[0,3], [𝘩𝘦𝘪𝘨𝘩𝘵] 𝘰𝘳 [𝘸𝘪𝘥𝘵𝘩] 𝘳𝘦𝘲𝘶𝘪𝘳𝘦𝘥 𝘴𝘪𝘻𝘪𝘯𝘨=3
------------------------------𝘪𝘨𝘯𝘰𝘳𝘦 𝘮𝘢𝘳𝘨𝘪𝘯
𝘴𝘪𝘻𝘪𝘯𝘨=0: 𝘮𝘢𝘪𝘯𝘵𝘢𝘪𝘯 𝘢𝘴𝘱𝘦𝘤𝘵 𝘳𝘢𝘵𝘪𝘰, 𝘳𝘦𝘴𝘪𝘻𝘦 𝘪𝘮𝘢𝘨𝘦: 𝘏𝘪𝘮𝘢𝘨𝘦 <= 𝘏𝘤𝘦𝘭𝘭, 𝘞𝘪𝘮𝘢𝘨𝘦 <= 𝘞𝘤𝘦𝘭𝘭
𝘴𝘪𝘻𝘪𝘯𝘨=1: 𝘪𝘨𝘯𝘰𝘳𝘦 𝘢𝘴𝘱𝘦𝘤𝘵 𝘳𝘢𝘵𝘪𝘰, 𝘳𝘦𝘴𝘪𝘻𝘦 𝘪𝘮𝘢𝘨𝘦: 𝘏𝘪𝘮𝘢𝘨𝘦 = 𝘏𝘤𝘦𝘭𝘭, 𝘞𝘪𝘮𝘢𝘨𝘦 = 𝘞𝘤𝘦𝘭𝘭
𝘴𝘪𝘻𝘪𝘯𝘨=2: 𝘮𝘢𝘪𝘯𝘵𝘢𝘪𝘯 𝘰𝘳𝘪𝘨𝘪𝘯𝘢𝘭 𝘪𝘮𝘢𝘨𝘦 𝘴𝘪𝘻𝘦.
𝘴𝘪𝘻𝘪𝘯𝘨=3: 𝘴𝘱𝘦𝘤𝘪𝘧𝘺 𝘪𝘮𝘢𝘨𝘦 𝘴𝘪𝘻𝘦 𝘪𝘯 𝘱𝘪𝘹𝘦𝘭𝘴.

=IMAGE("https://autechniques.com/excel/auexpress/functions/images/AI-Generated-art.webp")
//[𝘰𝘱𝘵𝘪𝘰𝘯𝘢𝘭]: 𝘢𝘭𝘵_𝘵𝘦𝘹𝘵="", 𝘴𝘪𝘻𝘪𝘯𝘨=[0,3], [𝘩𝘦𝘪𝘨𝘩𝘵] 𝘰𝘳 [𝘸𝘪𝘥𝘵𝘩] 𝘳𝘦𝘲𝘶𝘪𝘳𝘦𝘥 𝘴𝘪𝘻𝘪𝘯𝘨=3
------------------------------𝘪𝘨𝘯𝘰𝘳𝘦 𝘮𝘢𝘳𝘨𝘪𝘯
𝘴𝘪𝘻𝘪𝘯𝘨=0: 𝘮𝘢𝘪𝘯𝘵𝘢𝘪𝘯 𝘢𝘴𝘱𝘦𝘤𝘵 𝘳𝘢𝘵𝘪𝘰, 𝘳𝘦𝘴𝘪𝘻𝘦 𝘪𝘮𝘢𝘨𝘦: 𝘏𝘪𝘮𝘢𝘨𝘦 <= 𝘏𝘤𝘦𝘭𝘭, 𝘞𝘪𝘮𝘢𝘨𝘦 <= 𝘞𝘤𝘦𝘭𝘭
𝘴𝘪𝘻𝘪𝘯𝘨=1: 𝘪𝘨𝘯𝘰𝘳𝘦 𝘢𝘴𝘱𝘦𝘤𝘵 𝘳𝘢𝘵𝘪𝘰, 𝘳𝘦𝘴𝘪𝘻𝘦 𝘪𝘮𝘢𝘨𝘦: 𝘏𝘪𝘮𝘢𝘨𝘦 = 𝘏𝘤𝘦𝘭𝘭, 𝘞𝘪𝘮𝘢𝘨𝘦 = 𝘞𝘤𝘦𝘭𝘭
𝘴𝘪𝘻𝘪𝘯𝘨=2: 𝘮𝘢𝘪𝘯𝘵𝘢𝘪𝘯 𝘰𝘳𝘪𝘨𝘪𝘯𝘢𝘭 𝘪𝘮𝘢𝘨𝘦 𝘴𝘪𝘻𝘦.
𝘴𝘪𝘻𝘪𝘯𝘨=3: 𝘴𝘱𝘦𝘤𝘪𝘧𝘺 𝘪𝘮𝘢𝘨𝘦 𝘴𝘪𝘻𝘦 𝘪𝘯 𝘱𝘪𝘹𝘦𝘭𝘴.

=IMAGE("https://autechniques.com/excel/auexpress/functions/images/AI-Generated-art.webp")

RELATED