Aan de slagGa gratis aan de slag

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.

Deze oefening maakt deel uit van de cursus

Intermediate Google Sheets

Cursus bekijken

Oefeninstructies

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.

Praktische interactieve oefening

Zet theorie om in actie met een van onze interactieve oefeningen.

Begin met trainen