Začněte nyníZačněte zdarma

Lots of IFS

If you have more than two categories to generate from your logical conditions, IF() becomes unwieldy. It is possible to generate as many categories as you like by nesting IF() inside other calls to IF(), but the code quickly becomes difficult to understand. Instead, Google Sheets provides a function called IFS() that lets you test for as many conditions as you like. It takes pairs of arguments as follows:

=IFS(condition1, "value if condition 1 is TRUE", 
     condition2, "value if condition 2 is TRUE", ...)

Toto cvičení je součástí kurzu

Intermediate Google Sheets

Zobrazit kurz

Pokyny k cvičení

In column H, pass six arguments to IFS() to calculate the status of kids in each row. If the woman

  • has young kids, return "young".
  • has no kids, return "none".
  • has kids and does not have young kids, return "old".

Interaktivní praktické cvičení

Proměňte teorii v praxi s jedním z našich interaktivních cvičení

Začít cvičení