LoslegenKostenlos loslegen

Going missing

Some calculations involving blank values may give different results to what you might expect. For example, when you pass a blank value into the AND() function, it is treated as TRUE. This is often unhelpful. To make blanks behave in a sensible way in calculations, you must first convert them to be "not available" using NA(). This function takes no inputs, and returns a missing value. To convert a blank value to a missing value, use this pattern.

=IF(ISBLANK(cell), NA(), cell)

Diese Übung ist Teil des Kurses

Intermediate Google Sheets

Kurs anzeigen

Anleitung zur Übung

  • In column H, use AND() to find women who have kids and get benefits.
  • In column I, convert the blanks in column G to missing values.
  • In column J, again find women who have kids and get benefits, this time using column I rather than G.

Interaktive Übung

In dieser interaktiven Übung kannst du die Theorie in die Praxis umsetzen.

Übung starten