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...
Hot icon
By Google
https://github.com/googlei18n/noto-em...
Apache License 2.0
https://commons.wikimedia.org/w/index...
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:
• Collect Data into Google Sheets | For...
#googlesheets #IMAGEfunction #prolificoaktree
Watch video Google Sheets - Use Images in your Spreadsheet online, duration hours minute second in high quality that is uploaded to the channel Prolific Oaktree 31 March 2019. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 92,948 times and liked it 447 visitors.