Google Sheets - Use Images in your Spreadsheet



7
33558

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. 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

Published by: Prolific Oaktree Published at: 5 years ago Category: علمی و تکنولوژی