What is the Excel CHOOSE Function?
The excel CHOOSE function select a value in the list based on the given position.
CHOOSE Syntax
CHOOSE(index_num, value1, [value2], ...)
index_num, which argument value to choose. a number between 1 and 254
- If index_num is 1, CHOOSE returns value1; if it is 2, CHOOSE returns value2; and so on.
- If index_num less than 1 or greater than the number of value argument, CHOOSE returns #VALUE! error.
- If index_num is a fractional number, then excel truncates the decimal number, leaving the integer number.
value1, [value2], …, value1 is required, the following values are optional, could be a number, text, cell reference or even a formula, handles up to 254 value argument.
How to Use CHOOSE Function in Excel
Days of the Week in Frence
You can use the CHOOSE function in several conditions. For example, your current regional setting is “United States Format”, but you want to display days of the week in French. What should you do?
You cannot use the excel TEXT function, because it returns the days of the week in English, but you can use the excel CHOOSE function.
The Formula
=CHOOSE(A2,"Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi")
You got the day name in French only by giving the day number. Combine the formula with the excel WEEKDAY function; you got the day name of a date in French.
The Formula
=CHOOSE(WEEKDAY(A2,1),"Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi")
