ComeçarComece de graça

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.

Este exercício faz parte do curso

Intermediate Google Sheets

Ver curso

Instruções do exercício

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.

Exercício interativo prático

Transforme a teoria em ação com um de nossos exercícios interativos

Começar o exercício