The CHOOSE function
A list of values written in the formula, and a number saying which to return: a quarter's name, a code's label.
Syntax
=CHOOSE(index_num, value1, [value2], …)
In a French Excel: =CHOISIR(no_index; valeur1; [valeur2]; …).
Arguments
- index_num: 1 for the first value, 2 for the second…
- value1, value2…: up to 254 values.
An example
=CHOOSE(INT((MONTH(A2)+2)/3),"Q1","Q2","Q3","Q4")
The quarter of the date in A2.
Pitfalls
- A number outside the list: #VALUE!.
- Values written in the formula are hard to maintain: beyond a few, a table and XLOOKUP.
Going further
Frequently asked questions
- CHOOSE or SWITCH?
- CHOOSE takes a number; SWITCH compares a value with a list of cases, and has a default case.