The excel CHOOSE function select a value in the list based on the given position.
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.
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.
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.