Comparison operators and logicals
Comparison operators are used to compare cell values to evaluate whether they are equal to, not equal to, less than, or greater than one another. Comparison operators return a Boolean value (TRUE/FALSE), which is automatically assigned the logical data type.
In this exercise, you'll use comparison operators to identify items less than $1, and energy dense items. Here, the energy density is calculated by dividing the values in the KCal column by those in the Weight (g) column.
Bu egzersiz
Introduction to Google Sheets
kursunun bir parçasıdırEgzersiz talimatları
- In
F2:F5, use a comparison operator to determine whether each item costs less than $1. - In
G2:G5, use both an arithmetic operator and comparison operator to determine whether each item is energy dense, which is defined here as an item that has a KCal per gram of weight greater than or equal to3.
Uygulamalı interaktif egzersiz
İnteraktif egzersizlerimizden biriyle teoriyi pratiğe dökün
Egzersizi başlat