LoslegenKostenlos loslegen

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.

Diese Übung ist Teil des Kurses

Google Sheets: Fortgeschrittene Funktionen

Kurs anzeigen

Anleitung zur Übung

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.

Interaktive Übung

In dieser interaktiven Übung kannst du die Theorie in die Praxis umsetzen.

Übung starten