When the result is one of several values:
- two options —
IF(condition, yes, no); - three or more — nested
IFs, checked in order; - choice by number —
CHOOSE(index, option1, option2, …):=CHOOSE(3,"Mon","Tue","Wed")returns “Wed”.
Open the practice in the trainer →
When the result is one of several values:
IF(condition, yes, no);IFs, checked in order;CHOOSE(index, option1, option2, …): =CHOOSE(3,"Mon","Tue","Wed") returns “Wed”.