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.
이 연습은 강의의 일부입니다
Google Sheets 중급
연습 안내
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.
