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.
This exercise is part of the course
Intermediate Google Sheets
Exercise instructions
Count the number of records by cheating sprinters.
- In column
H, convert the logical values in columnGto ones and zeroes. - In
H22, count the number of cheats by calculating theSUM()ofH2toH20. - In
H23, count the proportion of cheats by calculating theAVERAGE()ofH2toH20.
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise