Mulai sekarangMulai gratis

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.

Latihan ini merupakan bagian dari kursus

Google Sheets Tingkat Menengah

Lihat Kursus

Instruksi latihan

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.

Latihan interaktif langsung

Ubah teori menjadi aksi dengan salah satu latihan interaktif kami

Mulai latihan