Syntax<\/h3>\n
CHOOSE(index, choice1, [choice2, \u2026])<\/strong><\/span><\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Let us start with the basic example that returns the weekday based on the index number. In the snapshot below, you can see the various combinations of the formula that we tried.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/CHOOSE-formula-1.png” alt=”CHOOSE formula 1″ title_text=”CHOOSE formula 1″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Like we mentioned above,\u00a0<\/span>the\u00a0range of the index values can only start from 1 and can\u2019t exceed the total number of choices within the formula. What happens if we try to force that? It coughs up errors of course! Let us try that firsthand. Below is the snapshot that demonstrates the outcome of using the index value 0.<\/span><\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/CHOOSE-formula-2.png” alt=”CHOOSE formula 2″ title_text=”CHOOSE formula 2″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Does the behavior change when we exceed the number of choices (in this case 3)? As it turns out, not really.<\/span><\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/CHOOSE-formula-3.png” alt=”CHOOSE formula 3″ title_text=”CHOOSE formula 3″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Similar is the case when the index number is either a negative number.<\/span><\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/CHOOSE-formula-4.png” alt=”CHOOSE formula 4″ title_text=”CHOOSE formula 4″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n What happens if the index is a decimal number? Surprisingly, it doesn\u2019t error out this time. The CHOOSE formula\u00a0<\/span>considers the value on the left of the decimal point\u00a0(in this case 2) and evaluates the formula accordingly.<\/span><\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/CHOOSE-formula-5.png” alt=”CHOOSE formula 5″ title_text=”CHOOSE formula 5″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" We may already be aware of the usability of the\u00a0nested IF\u00a0statements and\u00a0SWITCHformulas in Google Sheets. Going by the experience, we can conclude that the SWITCH formula is less complicated than that of the nested IF statement. On the similar lines, wouldn\u2019t it be nice if instead of specifying the case every time, we just\u00a0specify an […]<\/p>\n","protected":false},"author":40,"featured_media":3517,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"We may already be aware of the usability of the nested IF<\/a> statements and SWITCH<\/a> formulas in Google Sheets. Going by the experience, we can conclude that the SWITCH formula is less complicated than that of the nested IF statement. On the similar lines, wouldn't it be nice if instead of specifying the case every time, we just specify an index of sorts, and we get the corresponding value? Well, just to help us with that purpose, the Google Sheets application hosts the CHOOSE<\/a> formula.\n\n
Usage: CHOOSE Formula<\/h3>\n
Syntax<\/h3>\nCHOOSE(index, choice1, [choice2, ...])<\/strong><\/span>\n
\n \t
Usage: CHOOSE Formula<\/h3>\nLet us start with the basic example that returns the weekday based on the index number. In the snapshot below, are can see the various combinations of the formula that we tried.\n\n
![\"CHOOSE](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/choose1.png\")
\n\nLike we mentioned above, the range of the index values can only start from 1 and can't exceed the total number of choices within the formula. What happens if we try to force that? It coughs up errors of course! Let's us try that firsthand. Below is the snapshot that demonstrates the outcome of using the index value 0.\n\n![\"CHOOSE](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/choose2.png\")
\n\nDoes the behavior change when we exceed the number of choices (in this case 3)? As it turns out, not really.\n\n![\"CHOOSE](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/choose3.png\")
\n\nSimilar is the case when the index number is either a negative number.\n\n![\"CHOOSE](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/choose4.png\")
\n\nWhat happens if the index is a decimal number? Surprisingly, it doesn't error out this time. The CHOOSE formula considers the value on the left of the decimal point (in this case 2) and evaluates the formula accordingly.\n\n![\"CHOOSE](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/choose5.png\")
\n\n\u00a0","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[39,28],"class_list":["post-3365","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-formulas","tag-connections-t","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/3365","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=3365"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/3365\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/3517"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=3365"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=3365"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=3365"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}