Google Sheets Formulas: If with Image

preview_player
Показать описание
This video shows how to use the If formula to pull an image if the score is greater than a certain number. You can also use = or less than.
This formula tells the spreadsheet to look at the Sheet name and the Cell for H2. If the score is greater than 19, an image is pulled. The URL is to a published Google Drawing for a badge. Each challenge has its own badge that students can earn. You can nest IF statements so that if the score is less than 19 one image is shown and if the score is greater than 19 another image is shown.
Рекомендации по теме