Google Sheets - Use Images in your Spreadsheet
Channel: Prolific Oaktree
Date: 2019-03-31

Learn the different ways to insert images into Google Sheets. They can sit on top of the cells or inside of a cell. If you use the IMAGE function, they can be controlled by a formula.

The icons used in the video are attributed as follows:

Mild icon
By Google
editor Li Chao
CC BY-SA 4.0
https://commons.wikimedia.org/w/index.php?curid=46461410

Hot icon
By Google
https://github.com/googlei18n/noto-emoji/blob/f2a4f72/svg/emoji_u2600.svg
Apache License 2.0
https://commons.wikimedia.org/w/index.php?curid=34845260

Following in the spirit of sharing content with others, this video is Creative Commons so feel free to reuse and edit it as you wish. Please attribute my channel if you do.

The formula for the awesome weather calculator:

=IF(K33[*less than]=55,IMAGE("1st image URL"),IMAGE("2nd image URL"))
*Replace [less than] with the symbol. It can’t be used in a YouTube video description.

More information on the IMAGE function:
https://sheetshelp.com/google/image

Learn how to collect data into your Google Sheet using Google Forms: 
https://youtu.be/vQw2jDlylDU

#googlesheets #IMAGEfunction #prolificoaktree