# IMAGE

utility · from google sheets · excel: differs in detail · sheets: differs in detail

shows an image from a url: the browser loads it, the engine does not fetch

## signature

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

returns: `image`

## arguments

- url: text: required
- mode: number: optional
- height: number: optional
- width: number: optional

## examples

formula and result, asserted in the engine test suite.

| formula | result | with |
| --- | --- | --- |
| `=IMAGE("https://deepcalc.com/logo.png", 4, 20, 20)` | `{"url":"https://deepcalc.com/logo.png","mode":4,"height":20,"width":20}` | none |

## errors

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

| error | produced by |
| --- | --- |
| `#VALUE!` | `=IMAGE(2)` |

## related

- [FROMBYTES](https://deepcalc.com/docs/functions/frombytes.md): converts byte array to integer
- [GENERATEID](https://deepcalc.com/docs/functions/generateid.md): generates unique ID with prefix and random suffix
- [HASH](https://deepcalc.com/docs/functions/hash.md): hex digest of text: SHA256 (default, FIPS 180-4) or MD5 (RFC 1321)
- [ISIN](https://deepcalc.com/docs/functions/isin.md): checks if value is in a range or comma-separated list
- [RANDOMCHOICE](https://deepcalc.com/docs/functions/randomchoice.md): random pick from a range (with replacement); count > 1 spills a column
- [RANDOMINT.UNIQUE](https://deepcalc.com/docs/functions/randomint-unique.md): generates unique random integers in range
- [RANDOMNORMAL](https://deepcalc.com/docs/functions/randomnormal.md): generates random values from normal distribution
- [SPARKLINE](https://deepcalc.com/docs/functions/sparkline.md): draws a mini line or bar chart from a range: options take charttype, color, negcolor, linewidth, ymin and ymax

## navigate

- [all utility functions](https://deepcalc.com/docs/functions/utility-functions.md)
- [function index](https://deepcalc.com/docs/functions.md): all 602 functions
- [error values](https://deepcalc.com/docs/errors.md) · [concepts](https://deepcalc.com/docs/concepts.md) · [limits](https://deepcalc.com/docs/limits.md)
- [everything in one file](https://deepcalc.com/llms-full.txt)

source: https://deepcalc.com/docs/functions/image