BaşlayınÜcretsiz Başlayın

Converting logical values to numbers

In order to calculate on logical values, it is often useful to pretend that TRUE is 1 and FALSE is 0. Just as with text, to perform the conversion, you can use the N() function. This allows you to count the number or proportion of true values.

  • The SUM() of the ones gives you the count of true values.
  • The AVERAGE() of the ones and zeros gives you the proportion of true values.

Bu egzersiz

Intermediate Google Sheets

kursunun bir parçasıdır
Kursu Görüntüle

Egzersiz talimatları

Count the number of records by cheating sprinters.

  • In column H, convert the logical values in column G to ones and zeroes.
  • In H22, count the number of cheats by calculating the SUM() of H2 to H20.
  • In H23, count the proportion of cheats by calculating the AVERAGE() of H2 to H20.

Uygulamalı interaktif egzersiz

İnteraktif egzersizlerimizden biriyle teoriyi pratiğe dökün

Egzersizi başlat