{"id":3165,"date":"2020-12-03T12:04:01","date_gmt":"2020-12-03T11:04:01","guid":{"rendered":"https:\/\/www.sheetgo.com\/?p=3165"},"modified":"2020-12-03T12:04:01","modified_gmt":"2020-12-03T11:04:01","slug":"formula-ifs-google-sheets","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/es\/blog\/google-sheets-formulas\/ifs-formula-google-sheets\/","title":{"rendered":"C\u00f3mo utilizar la funci\u00f3n IFS en Google Sheets"},"content":{"rendered":"\n[et_pb_section fb_built=”1″ admin_label=”section” module_class=”sheetgo-post” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_row _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.24.1″ global_colors_info=”{}” theme_builder_area=”post_content”]

The IF function in Google Sheets enables logical decision making with a simple if-else structure. It checks whether a condition in a cell is true or false. IFS supercharges this function and lets you check against multiple conditions at once.<\/span><\/p>\n

You could achieve the same result by nesting IF functions but it can result in a very long formula. And this can be difficult to work with and lead to errors in your spreadsheet.<\/span><\/p>\n

This is where IFS comes in handy. This formula takes a set of expression and value pairs, evaluates them, and returns the first value of an expression that\u2019s TRUE.<\/span><\/p>\n

This works exactly the same as the Excel IFS function, so if that\u2019s your preferred software you can still follow along.<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>[\/et_pb_text][et_pb_text admin_label=”Connections T – Automate beyond importrange – Horizontal” module_class=”sheetgo-post-no-shadow-img md2-contained-button-light vertical-banner-container” _builder_version=”4.27.2″ _module_preset=”default” background_color=”#f2f7ff” max_width=”700px” module_alignment=”center” max_height=”300px” custom_margin=”20px|0px|20px|0px|true|true” custom_padding=”25px|25px|25px|25px|true|true” sticky_limit_bottom=”section” border_radii=”on|20px|20px|20px|20px” border_width_all=”1px” border_color_all=”#d9e7ff” saved_tabs=”all” global_colors_info=”{}” global_module=”50462″ theme_builder_area=”post_content”]\"\"\n\n\"39\"\n\nAutomate data transfers beyond Importrange<\/span>\n\nFind out how<\/a>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]

Syntax<\/h3>[\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]

=IFS(expression1, value1, [expression2, value2], \u2026)<\/span><\/p>[\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]