The IMAGE function lets a spreadsheet user insert an image into a cell. You must specify the source of the picture file as a URL.
url– The location of the image on the web – (“https://www.wheremypicis.com/mypic.png”). You must either use quotation marks around the URL or put it in another cell and reference it.
[mode]– Optional specification of how to size the image.
- 1 – Resize to fit the cell. Maintains the same aspect ratio, so the image does not look distorted.
- 2 – Makes the image fit the entire cell. Will disregard the aspect ratio.
- 3 – Maintains original size even it gets cropped.
- 4 – Custom
[height]– If you specify 4 for custom mode, use this for the height.
[width]– If you specify 4 for custom mode, use this for the width.
#N/A – The function does not have enough arguments. This error can occur because you used option #4 but did not specify height and width arguments. Possibly because you used option #4 but did not specify height and width.
Live examples in Sheets
Go to this spreadsheet for examples of the IMAGE function shown above that you can study and use anywhere you would like.