AND now for something completely different
Sometimes you want to know if several logical conditions are all true at the same time. For this you can use the AND() function.
AND(TRUE, TRUE, TRUE) returns TRUE, since all the inputs are TRUE. AND(TRUE, FALSE, TRUE) returns false, since the second input is not TRUE.
Bu egzersiz, kursun bir parçasıdır
Orta Düzey Google Sheets
Egzersiz talimatları
- In column
H, find the women who are married and have kids, but not young kids. - In cell
A28, define a filter to return only the rows where columnHisTRUE.
Uygulamalı etkileşimli egzersiz
Teoriyi etkileşime dönüştürün, interaktif egzersizlerimizden biriyle
Egzersize başla