{"id":51810,"date":"2025-01-07T22:17:24","date_gmt":"2025-01-07T21:17:24","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=51810"},"modified":"2025-06-03T22:09:40","modified_gmt":"2025-06-03T20:09:40","slug":"dominar-a-formula-ifs-simplifica-a-logica-condicional-nas-planilhas-do-google","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/pt\/blog\/google-sheets-formulas\/mastering-the-ifs-formula-simplify-conditional-logic-in-google-sheets\/","title":{"rendered":"Dominando a f\u00f3rmula IFs: simplifique a l\u00f3gica condicional no Planilhas Google"},"content":{"rendered":"\n[et_pb_section fb_built=&#8221;1&#8243; theme_builder_area=&#8221;post_content&#8221; _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221;][et_pb_row _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; type=&#8221;4_4&#8243; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; theme_builder_area=&#8221;post_content&#8221; hover_enabled=&#8221;0&#8243; sticky_enabled=&#8221;0&#8243;]<p><span style=\"font-weight: 400;\">The IFS formula in Google Sheets is ideal for evaluating multiple conditions in a single formula. Whether tracking stock levels, managing sales data, or handling inventory, this formula simplifies complex logical operations and ensures efficient decision-making.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Let\u2019s explore how the IFS formula works and highlight its practical applications with real-life examples.<\/span><\/p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; theme_builder_area=&#8221;post_content&#8221; hover_enabled=&#8221;0&#8243; sticky_enabled=&#8221;0&#8243;]<h3><b>IFS formula syntax<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">The IFS formula evaluates multiple conditions and returns the first result where the condition is TRUE. Unlike IF, which requires nesting for multiple conditions, the IFS formula handles them easily.<\/span><\/p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; theme_builder_area=&#8221;post_content&#8221; hover_enabled=&#8221;0&#8243; sticky_enabled=&#8221;0&#8243; module_class=&#8221;spreadsheet-function&#8221;]<p><span style=\"font-weight: 400;\">=IFS(condition1, value_if_true1, [condition2, value_if_true2], \u2026)<\/span><\/p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; theme_builder_area=&#8221;post_content&#8221; hover_enabled=&#8221;0&#8243; sticky_enabled=&#8221;0&#8243;]<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>condition1<\/b><span style=\"font-weight: 400;\">: The first condition to test.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>value_if_true1<\/b><span style=\"font-weight: 400;\">: The value to return if <\/span><span style=\"font-weight: 400;\">condition1<\/span><span style=\"font-weight: 400;\"> is TRUE.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>condition2<\/b><span>, <\/span><b>value_if_true2<\/b><span>, etc.: Additional conditions and their respective results.<\/span><\/li>\n<\/ul>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; theme_builder_area=&#8221;post_content&#8221; hover_enabled=&#8221;0&#8243; sticky_enabled=&#8221;0&#8243;]<h3><b>Why use the IFS formula?<\/b><\/h3>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Eliminates the need for cumbersome nested <\/span><span style=\"font-weight: 400;\">IF<\/span><span style=\"font-weight: 400;\"> formulas.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Handles multiple conditions with clarity and precision.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Offers flexible, dynamic logic for advanced calculations.<\/span><\/li>\n<\/ul>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; theme_builder_area=&#8221;post_content&#8221; hover_enabled=&#8221;0&#8243; sticky_enabled=&#8221;0&#8243;]<h3><b>1. Managing inventory restocking<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Scenario: Calculate stock status based on specific thresholds.<\/span><\/p>\n<table>\n<tbody>\n<tr>\n<td>\n<p><span style=\"font-weight: 400;\">A<\/span><\/p>\n<\/td>\n<td>\n<p><span style=\"font-weight: 400;\">B<\/span><\/p>\n<\/td>\n<td>\n<p><span style=\"font-weight: 400;\">C<\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p><b>Product<\/b><\/p>\n<\/td>\n<td>\n<p><b>Stock Level<\/b><\/p>\n<\/td>\n<td>\n<p><b>Status<\/b><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p><span style=\"font-weight: 400;\">Product A<\/span><\/p>\n<\/td>\n<td>\n<p><span style=\"font-weight: 400;\">5<\/span><\/p>\n<\/td>\n<td>\n<p><span style=\"font-weight: 400;\">Reorder Soon<\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p><span style=\"font-weight: 400;\">Product B<\/span><\/p>\n<\/td>\n<td>\n<p><span style=\"font-weight: 400;\">0<\/span><\/p>\n<\/td>\n<td>\n<p><span style=\"font-weight: 400;\">Out of Stock<\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p><span style=\"font-weight: 400;\">Product C<\/span><\/p>\n<\/td>\n<td>\n<p><span style=\"font-weight: 400;\">50<\/span><\/p>\n<\/td>\n<td>\n<p><span style=\"font-weight: 400;\">In Stock<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; theme_builder_area=&#8221;post_content&#8221; hover_enabled=&#8221;0&#8243; sticky_enabled=&#8221;0&#8243; module_class=&#8221;spreadsheet-function&#8221;]<p><span style=\"font-weight: 400;\">=IFS(<\/span><span style=\"font-weight: 400;\">B5<\/span><span style=\"font-weight: 400;\">=<\/span><span style=\"font-weight: 400;\">0<\/span><span style=\"font-weight: 400;\">, <\/span><span style=\"font-weight: 400;\">&#8220;Out of Stock&#8221;<\/span><span style=\"font-weight: 400;\">, <\/span><span style=\"font-weight: 400;\">B5<\/span><span style=\"font-weight: 400;\">&lt;<\/span><span style=\"font-weight: 400;\">10<\/span><span style=\"font-weight: 400;\">, <\/span><span style=\"font-weight: 400;\">&#8220;Reorder Soon&#8221;<\/span><span style=\"font-weight: 400;\">, <\/span><span style=\"font-weight: 400;\">B5<\/span><span style=\"font-weight: 400;\">&gt;=<\/span><span style=\"font-weight: 400;\">10<\/span><span style=\"font-weight: 400;\">, <\/span><span style=\"font-weight: 400;\">&#8220;In Stock&#8221;<\/span><span style=\"font-weight: 400;\">)<\/span><\/p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; theme_builder_area=&#8221;post_content&#8221; hover_enabled=&#8221;0&#8243; sticky_enabled=&#8221;0&#8243;]<h4><b>Formula breakdown:<\/b><\/h4>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Condition 1: <\/b><span style=\"font-weight: 400;\">B5=0, &#8220;Out of Stock&#8221;<\/span>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">If the value in <\/span><span style=\"font-weight: 400;\">B5<\/span><span style=\"font-weight: 400;\"> is exactly <\/span><b>0<\/b><span style=\"font-weight: 400;\">, the formula returns <\/span><b>&#8220;Out of Stock&#8221;<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<\/ul>\n<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Condition 2: <\/b><span style=\"font-weight: 400;\">B5&lt;10, &#8220;Reorder Soon&#8221;<\/span>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">If the value in <\/span><span style=\"font-weight: 400;\">B5<\/span><span style=\"font-weight: 400;\"> is less than <\/span><b>10<\/b><span style=\"font-weight: 400;\"> (but not 0), the formula returns <\/span><b>&#8220;Reorder Soon&#8221;<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<\/ul>\n<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Condition 3: <\/b><span style=\"font-weight: 400;\">B5&gt;=10, &#8220;In Stock&#8221;<\/span>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">If the value in <\/span><span style=\"font-weight: 400;\">B5<\/span><span style=\"font-weight: 400;\"> is greater than or equal to <\/span><b>10<\/b><span style=\"font-weight: 400;\">, the formula returns <\/span><b>&#8220;In Stock&#8221;<\/b><b><\/b><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><b><a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1vEDmN9U-t6lAalxlpVwpP21gkcNBpvvFjSVqY8GjR84\/edit?gid=346989325#gid=346989325\" target=\"_blank\" rel=\"noopener\"><i><span style=\"font-weight: 400;\">Check the formula in the spreadsheet<\/span><\/i><\/a><\/b><\/p>\n<h3>\n<\/h3>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; theme_builder_area=&#8221;post_content&#8221; hover_enabled=&#8221;0&#8243; sticky_enabled=&#8221;0&#8243;]<h4><span style=\"font-weight: 400;\">How it works:<\/span><\/h4>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">If the stock level is <\/span><span style=\"font-weight: 400;\">0<\/span><span style=\"font-weight: 400;\">, it returns <\/span><b>&#8220;Out of Stock&#8221;<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">If the stock level is less than <\/span><span style=\"font-weight: 400;\">10<\/span><span style=\"font-weight: 400;\">, it returns <\/span><b>&#8220;Reorder Soon&#8221;<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\">Otherwise, it returns <b>&#8220;In Stock&#8221;<\/b><span>.<\/span><\/li>\n<\/ul>\n<h4><span style=\"font-weight: 400;\">Benefits:<\/span><\/h4>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Automatically tracks stock status without manual intervention.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Helps in maintaining optimal inventory levels.<\/span><\/li>\n<\/ul>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; theme_builder_area=&#8221;post_content&#8221; hover_enabled=&#8221;0&#8243; sticky_enabled=&#8221;0&#8243;]<h3><span style=\"font-weight: 400;\">2. Stage-Wise Sales Breakup<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Scenario: Categorize sales leads based on their status.<\/span><\/p>\n<table>\n<tbody>\n<tr>\n<td>\n<p><span style=\"font-weight: 400;\">A<\/span><\/p>\n<\/td>\n<td>\n<p><span style=\"font-weight: 400;\">B<\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p><b>Lead Status<\/b><\/p>\n<\/td>\n<td>\n<p><b>Stage<\/b><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p><span style=\"font-weight: 400;\">Target<\/span><\/p>\n<\/td>\n<td>\n<p><span style=\"font-weight: 400;\">Initial<\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p><span style=\"font-weight: 400;\">Contract Generated<\/span><\/p>\n<\/td>\n<td>\n<p><span style=\"font-weight: 400;\">Negotiation<\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p><span style=\"font-weight: 400;\">Lost<\/span><\/p>\n<\/td>\n<td>\n<p><span style=\"font-weight: 400;\">Closed &#8211; Lost<\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p><span style=\"font-weight: 400;\">Won<\/span><\/p>\n<\/td>\n<td>\n<p><span style=\"font-weight: 400;\">Closed &#8211; Won<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; theme_builder_area=&#8221;post_content&#8221; hover_enabled=&#8221;0&#8243; sticky_enabled=&#8221;0&#8243; module_class=&#8221;spreadsheet-function&#8221;]<p><span style=\"font-weight: 400;\">=IFS(<\/span><span style=\"font-weight: 400;\">A5<\/span><span style=\"font-weight: 400;\">=<\/span><span style=\"font-weight: 400;\">&#8220;Target&#8221;<\/span><span style=\"font-weight: 400;\">, <\/span><span style=\"font-weight: 400;\">&#8220;Initial&#8221;<\/span><span style=\"font-weight: 400;\">, <\/span><span style=\"font-weight: 400;\">A5<\/span><span style=\"font-weight: 400;\">=<\/span><span style=\"font-weight: 400;\">&#8220;Contract Generated&#8221;<\/span><span style=\"font-weight: 400;\">, <\/span><span style=\"font-weight: 400;\">&#8220;Negotiation&#8221;<\/span><span style=\"font-weight: 400;\">, <\/span><span style=\"font-weight: 400;\">A5<\/span><span style=\"font-weight: 400;\">=<\/span><span style=\"font-weight: 400;\">&#8220;Lost&#8221;<\/span><span style=\"font-weight: 400;\">, <\/span><span style=\"font-weight: 400;\">&#8220;Closed &#8211; Lost&#8221;<\/span><span style=\"font-weight: 400;\">, <\/span><span style=\"font-weight: 400;\">A5<\/span><span style=\"font-weight: 400;\">=<\/span><span style=\"font-weight: 400;\">&#8220;Won&#8221;<\/span><span style=\"font-weight: 400;\">, <\/span><span style=\"font-weight: 400;\">&#8220;Closed &#8211; Won&#8221;<\/span><span style=\"font-weight: 400;\">)<\/span><\/p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; theme_builder_area=&#8221;post_content&#8221; hover_enabled=&#8221;0&#8243; sticky_enabled=&#8221;0&#8243;]<h4><b>Formula breakdown<\/b><\/h4>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Condition 1: <\/b><span style=\"font-weight: 400;\">A5=&#8221;Target&#8221;, &#8220;Initial&#8221;<\/span><\/li>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">If the value in <\/span><span style=\"font-weight: 400;\">A5<\/span><span style=\"font-weight: 400;\"> is <\/span><b>&#8220;Target&#8221;<\/b><span style=\"font-weight: 400;\">, the formula returns <\/span><b>&#8220;Initial&#8221;<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<\/ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Condition 2: <\/b><span style=\"font-weight: 400;\">A5=&#8221;Contract Generated&#8221;, &#8220;Negotiation&#8221;<\/span><\/li>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">If the value in <\/span><span style=\"font-weight: 400;\">A5<\/span><span style=\"font-weight: 400;\"> is <\/span><b>&#8220;Contract Generated&#8221;<\/b><span style=\"font-weight: 400;\">, the formula returns <\/span><b>&#8220;Negotiation&#8221;<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<\/ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Condition 3: <\/b><span style=\"font-weight: 400;\">A5=&#8221;Lost&#8221;, &#8220;Closed &#8211; Lost&#8221;<\/span><\/li>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">If the value in <\/span><span style=\"font-weight: 400;\">A5<\/span><span style=\"font-weight: 400;\"> is <\/span><b>&#8220;Lost&#8221;<\/b><span style=\"font-weight: 400;\">, the formula returns <\/span><b>&#8220;Closed &#8211; Lost&#8221;<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<\/ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Condition 4: <\/b><span style=\"font-weight: 400;\">A5=&#8221;Won&#8221;, &#8220;Closed &#8211; Won&#8221;<\/span><\/li>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">If the value in <\/span><span style=\"font-weight: 400;\">A5<\/span><span style=\"font-weight: 400;\"> is <\/span><b>&#8220;Won&#8221;<\/b><span style=\"font-weight: 400;\">, the formula returns <\/span><b>&#8220;Closed &#8211; Won&#8221;<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<\/ul>\n<\/ul>\n<p><span style=\"font-weight: 400;\"><a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1vEDmN9U-t6lAalxlpVwpP21gkcNBpvvFjSVqY8GjR84\/copy\" target=\"_blank\" rel=\"noopener\"><i>Check out the formula in the spreadsheet<\/i><\/a><\/span><\/p>\n<h4><span style=\"font-weight: 400;\">How it works<\/span><\/h4>\n<p><span style=\"font-weight: 400;\">Matches the lead status with predefined stages and returns the corresponding stage.<\/span><\/p>\n<h4><span style=\"font-weight: 400;\">Benefits<\/span><\/h4>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Provides dynamic categorization for leads, aiding in better sales tracking.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Simplifies sales pipeline visualization.<\/span><\/li>\n<\/ul>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; theme_builder_area=&#8221;post_content&#8221; hover_enabled=&#8221;0&#8243; sticky_enabled=&#8221;0&#8243;]<h3><span style=\"font-weight: 400;\">3. Student Grading System Based on Scores<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Scenario: A teacher wants to assign grades to students based on their test scores using specific criteria.<\/span><\/p>\n<table>\n<tbody>\n<tr>\n<td>\n<p><span style=\"font-weight: 400;\">A<\/span><\/p>\n<\/td>\n<td>\n<p><span style=\"font-weight: 400;\">B<\/span><\/p>\n<\/td>\n<td>\n<p><span style=\"font-weight: 400;\">C<\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p><b>Student Name<\/b><\/p>\n<\/td>\n<td>\n<p><b>Score<\/b><\/p>\n<\/td>\n<td>\n<p><b>Grade<\/b><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p><span style=\"font-weight: 400;\">Alice Johnson<\/span><\/p>\n<\/td>\n<td>\n<p><span style=\"font-weight: 400;\">85<\/span><\/p>\n<\/td>\n<td>\n<p><span style=\"font-weight: 400;\">A<\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p><span style=\"font-weight: 400;\">Bob Carter<\/span><\/p>\n<\/td>\n<td>\n<p><span style=\"font-weight: 400;\">72<\/span><\/p>\n<\/td>\n<td>\n<p><span style=\"font-weight: 400;\">B<\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p><span style=\"font-weight: 400;\">Clara Lopez<\/span><\/p>\n<\/td>\n<td>\n<p><span style=\"font-weight: 400;\">90<\/span><\/p>\n<\/td>\n<td>\n<p><span style=\"font-weight: 400;\">A<\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p><span style=\"font-weight: 400;\">David Brown<\/span><\/p>\n<\/td>\n<td>\n<p><span style=\"font-weight: 400;\">65<\/span><\/p>\n<\/td>\n<td>\n<p><span style=\"font-weight: 400;\">C<\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p><span style=\"font-weight: 400;\">Emma White<\/span><\/p>\n<\/td>\n<td>\n<p><span style=\"font-weight: 400;\">50<\/span><\/p>\n<\/td>\n<td>\n<p><span style=\"font-weight: 400;\">D<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; theme_builder_area=&#8221;post_content&#8221; hover_enabled=&#8221;0&#8243; sticky_enabled=&#8221;0&#8243; module_class=&#8221;spreadsheet-function&#8221;]<p><span style=\"font-weight: 400;\">=IFS(<\/span><span style=\"font-weight: 400;\">B5<\/span><span style=\"font-weight: 400;\">=<\/span><span style=\"font-weight: 400;\">&#8220;&#8221;<\/span><span style=\"font-weight: 400;\">, <\/span><span style=\"font-weight: 400;\">&#8220;Missing Data&#8221;<\/span><span style=\"font-weight: 400;\">, <\/span><span style=\"font-weight: 400;\">B5<\/span><span style=\"font-weight: 400;\">&gt;=<\/span><span style=\"font-weight: 400;\">85<\/span><span style=\"font-weight: 400;\">, <\/span><span style=\"font-weight: 400;\">&#8220;A&#8221;<\/span><span style=\"font-weight: 400;\">, <\/span><span style=\"font-weight: 400;\">B5<\/span><span style=\"font-weight: 400;\">&gt;=<\/span><span style=\"font-weight: 400;\">70<\/span><span style=\"font-weight: 400;\">, <\/span><span style=\"font-weight: 400;\">&#8220;B&#8221;<\/span><span style=\"font-weight: 400;\">, <\/span><span style=\"font-weight: 400;\">B5<\/span><span style=\"font-weight: 400;\">&gt;=<\/span><span style=\"font-weight: 400;\">60<\/span><span style=\"font-weight: 400;\">, <\/span><span style=\"font-weight: 400;\">&#8220;C&#8221;<\/span><span style=\"font-weight: 400;\">, <\/span><span style=\"font-weight: 400;\">B5<\/span><span style=\"font-weight: 400;\">&lt;<\/span><span style=\"font-weight: 400;\">60<\/span><span style=\"font-weight: 400;\">, <\/span><span style=\"font-weight: 400;\">&#8220;D&#8221;<\/span><span style=\"font-weight: 400;\">)<\/span><\/p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; theme_builder_area=&#8221;post_content&#8221; hover_enabled=&#8221;0&#8243; sticky_enabled=&#8221;0&#8243;]<h4><b>Formula breakdown<\/b><\/h4>\n<ul>\n<li aria-level=\"1\"><b>Condition 1:<\/b><\/li>\n<\/ul>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li aria-level=\"2\"><b>B5=&#8221;&#8221;<\/b><b>, <\/b><b>&#8220;Missing Data&#8221;<\/b><b>: <\/b><span style=\"font-weight: 400;\">If the cell <\/span><span style=\"font-weight: 400;\">B5<\/span><span style=\"font-weight: 400;\"> is blank, the formula returns &#8220;Missing Data&#8221;.<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li aria-level=\"1\"><b>Condition 2:<\/b><\/li>\n<\/ul>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li aria-level=\"2\"><b>B5&gt;=85, &#8220;A&#8221;<\/b><b>: <\/b><span style=\"font-weight: 400;\">If the score is greater than or equal to 85, it returns &#8220;A&#8221;.<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li aria-level=\"1\"><b>Condition 3:<\/b><\/li>\n<\/ul>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li aria-level=\"2\"><b>B5&gt;=70, &#8220;B&#8221;<\/b><b>: <\/b><span style=\"font-weight: 400;\">If the score is greater than or equal to 70 but less than 85, it returns &#8220;B&#8221;.<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li aria-level=\"1\"><b>Condition 4:<\/b><\/li>\n<\/ul>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li aria-level=\"2\"><b>B5&gt;=60, &#8220;C&#8221;<\/b><b>: <\/b><span style=\"font-weight: 400;\">If the score is greater than or equal to 60 but less than 70, it returns &#8220;C&#8221;.<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li aria-level=\"1\"><b>Condition 5:<\/b><\/li>\n<\/ul>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li aria-level=\"2\"><b>B5&lt;60, &#8220;D&#8221;<\/b><b>:<\/b><span style=\"font-weight: 400;\"> If the score is less than 60, it returns &#8220;D&#8221;.<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1vEDmN9U-t6lAalxlpVwpP21gkcNBpvvFjSVqY8GjR84\/copy\" target=\"_blank\" rel=\"noopener\"><i><span style=\"font-weight: 400;\">Check out the formula in the spreadsheet<\/span><\/i><\/a><\/p>\n<h4><span style=\"font-weight: 400;\">How it works<\/span><\/h4>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">The formula starts by checking if <\/span><b>B5 is blank<\/b><span style=\"font-weight: 400;\">. If true, it immediately returns <\/span><b>&#8220;Missing Data&#8221;<\/b><span style=\"font-weight: 400;\"> and stops further evaluation.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">If <\/span><b>B5 has a score<\/b><span style=\"font-weight: 400;\">, it evaluates the score against the conditions in sequential order:<\/span><\/li>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">If <\/span><b>B5 &gt;= 85<\/b><span style=\"font-weight: 400;\">, it assigns <\/span><b>&#8220;A&#8221;<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">If <\/span><b>B5 &gt;= 70<\/b><span style=\"font-weight: 400;\">, it assigns <\/span><b>&#8220;B&#8221;<\/b><span style=\"font-weight: 400;\"> (only if the score doesn\u2019t qualify for &#8220;A&#8221;).<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">If <\/span><b>B5 &gt;= 60<\/b><span style=\"font-weight: 400;\">, it assigns <\/span><b>&#8220;C&#8221;<\/b><span style=\"font-weight: 400;\"> (only if the score doesn\u2019t qualify for &#8220;A&#8221; or &#8220;B&#8221;).<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">If <\/span><b>B5 &lt; 60<\/b><span style=\"font-weight: 400;\">, it assigns <\/span><b>&#8220;D&#8221;<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<\/ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">The <\/span><b>IFS<\/b><span style=\"font-weight: 400;\"> formula stops evaluating as soon as it finds a condition that is <\/span><b>TRUE<\/b><span style=\"font-weight: 400;\">, ensuring efficiency.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Handles missing data and assigns appropriate grades automatically, saving time and reducing errors.<\/span><\/li>\n<\/ul>\n<h4><span style=\"font-weight: 400;\">Benefits<\/span><\/h4>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Simplifies Logic: <\/b><span style=\"font-weight: 400;\">Eliminates the need for nested IF statements, making formulas easier to read and manage.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Handles Multiple Conditions: <\/b><span style=\"font-weight: 400;\">Efficiently evaluates multiple criteria in a single formula.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Dynamic and Flexible: <\/b><span style=\"font-weight: 400;\">Adapts to different scenarios like grading, approvals, or categorization.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Improves Clarity: <\/b><span style=\"font-weight: 400;\">Provides clear outputs based on logical conditions, enhancing data interpretation.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Error-Free Execution: <\/b><span style=\"font-weight: 400;\">Stops at the first TRUE condition, reducing unnecessary calculations.<\/span><\/li>\n<\/ul>\n<h3><b><\/b><\/p>\n<\/h3>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; theme_builder_area=&#8221;post_content&#8221; hover_enabled=&#8221;0&#8243; sticky_enabled=&#8221;0&#8243;]<h3><span style=\"font-weight: 400;\">4. Conditional Payment Approvals<\/span><\/h3>\n<p><b>Scenario:<\/b><span style=\"font-weight: 400;\"> A finance team wants to approve payments based on conditions such as payment amount and supporting documents.<\/span><\/p>\n<table>\n<tbody>\n<tr>\n<td>\n<p><span style=\"font-weight: 400;\">A<\/span><\/p>\n<\/td>\n<td>\n<p><span style=\"font-weight: 400;\">B<\/span><\/p>\n<\/td>\n<td>\n<p><span style=\"font-weight: 400;\">C<\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p><b>Student Name<\/b><\/p>\n<\/td>\n<td>\n<p><b>Grade<\/b><\/p>\n<\/td>\n<td>\n<p><b>Attendance (%)<\/b><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p><span style=\"font-weight: 400;\">Alice Johnson<\/span><\/p>\n<\/td>\n<td>\n<p><span style=\"font-weight: 400;\">A<\/span><\/p>\n<\/td>\n<td>\n<p><span style=\"font-weight: 400;\">95%<\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p><span style=\"font-weight: 400;\">Ben Carter<\/span><\/p>\n<\/td>\n<td>\n<p><span style=\"font-weight: 400;\">B+<\/span><\/p>\n<\/td>\n<td>\n<p><span style=\"font-weight: 400;\">88%<\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p><span style=\"font-weight: 400;\">Clara Lopez<\/span><\/p>\n<\/td>\n<td>\n<p><span style=\"font-weight: 400;\">A-<\/span><\/p>\n<\/td>\n<td>\n<p><span style=\"font-weight: 400;\">90%<\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p><span style=\"font-weight: 400;\">David Brown<\/span><\/p>\n<\/td>\n<td>\n<p><span style=\"font-weight: 400;\">B<\/span><\/p>\n<\/td>\n<td>\n<p><span style=\"font-weight: 400;\">85%<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; theme_builder_area=&#8221;post_content&#8221; hover_enabled=&#8221;0&#8243; sticky_enabled=&#8221;0&#8243; module_class=&#8221;spreadsheet-function&#8221;]<p><span style=\"font-weight: 400;\">=IFS(<\/span><span style=\"font-weight: 400;\">C5<\/span><span style=\"font-weight: 400;\">=<\/span><span style=\"font-weight: 400;\">&#8220;No&#8221;<\/span><span style=\"font-weight: 400;\">, <\/span><span style=\"font-weight: 400;\">&#8220;Pending&#8221;<\/span><span style=\"font-weight: 400;\">, AND(<\/span><span style=\"font-weight: 400;\">B5<\/span><span style=\"font-weight: 400;\">&lt;=<\/span><span style=\"font-weight: 400;\">1000<\/span><span style=\"font-weight: 400;\">, <\/span><span style=\"font-weight: 400;\">C5<\/span><span style=\"font-weight: 400;\">=<\/span><span style=\"font-weight: 400;\">&#8220;Yes&#8221;<\/span><span style=\"font-weight: 400;\">), <\/span><span style=\"font-weight: 400;\">&#8220;Approved&#8221;<\/span><span style=\"font-weight: 400;\">, AND(<\/span><span style=\"font-weight: 400;\">B5<\/span><span style=\"font-weight: 400;\">&gt;<\/span><span style=\"font-weight: 400;\">1000<\/span><span style=\"font-weight: 400;\">, <\/span><span style=\"font-weight: 400;\">C5<\/span><span style=\"font-weight: 400;\">=<\/span><span style=\"font-weight: 400;\">&#8220;Yes&#8221;<\/span><span style=\"font-weight: 400;\">), <\/span><span style=\"font-weight: 400;\">&#8220;Approved&#8221;<\/span><span style=\"font-weight: 400;\">, <\/span><span style=\"font-weight: 400;\">B5<\/span><span style=\"font-weight: 400;\">&gt;<\/span><span style=\"font-weight: 400;\">1000<\/span><span style=\"font-weight: 400;\">, <\/span><span style=\"font-weight: 400;\">&#8220;Pending&#8221;<\/span><span style=\"font-weight: 400;\">)<\/span><\/p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; theme_builder_area=&#8221;post_content&#8221; hover_enabled=&#8221;0&#8243; sticky_enabled=&#8221;0&#8243;]<h4><b>Formula breakdown<\/b><\/h4>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Condition 1<\/b><span style=\"font-weight: 400;\">:<\/span><\/li>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">C5=&#8221;No&#8221;, &#8220;Pending&#8221;<\/span><span style=\"font-weight: 400;\">: If the documents are not submitted (<\/span><span style=\"font-weight: 400;\">C5=&#8221;No&#8221;<\/span><span style=\"font-weight: 400;\">), the status is <\/span><b>&#8220;Pending&#8221;<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<\/ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Condition 2<\/b><span style=\"font-weight: 400;\">:<\/span><\/li>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">AND(B5&lt;=1000, C5=&#8221;Yes&#8221;), &#8220;Approved&#8221;<\/span><span style=\"font-weight: 400;\">: If the payment amount is less than or equal to $1,000 and documents are submitted, the status is <\/span><b>&#8220;Approved&#8221;<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<\/ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Condition 3<\/b><span style=\"font-weight: 400;\">:<\/span><\/li>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">AND(B5&gt;1000, C5=&#8221;Yes&#8221;), &#8220;Approved&#8221;<\/span><span style=\"font-weight: 400;\">: If the payment amount is greater than $1,000 and documents are submitted, the status is <\/span><b>&#8220;Approved&#8221;<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<\/ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Condition 4<\/b><span style=\"font-weight: 400;\">:<\/span><\/li>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">B5&gt;1000, &#8220;Pending&#8221;<\/span><span style=\"font-weight: 400;\">: If the payment amount is greater than $1,000 but documents are not submitted, the status is <\/span><b>&#8220;Pending&#8221;<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<\/ul>\n<\/ul>\n<p><a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1vEDmN9U-t6lAalxlpVwpP21gkcNBpvvFjSVqY8GjR84\/copy\" target=\"_blank\" rel=\"noopener\"><i><span style=\"font-weight: 400;\">Check out the formula in the spreadsheet<\/span><\/i><\/a><\/p>\n<h4><span style=\"font-weight: 400;\">How it works<\/span><\/h4>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Checks if the payment amount is missing and returns &#8220;Missing Data&#8221;.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">If documents are not submitted, it marks the payment as &#8220;Pending&#8221;.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Approves payments if the amount is within the limit and documents are submitted.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Marks large payments as &#8220;Pending&#8221; if documents are not provided.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Stops checking once a condition is met and returns the result.<\/span><\/li>\n<\/ul>\n<h4><span style=\"font-weight: 400;\">Benefits<\/span><\/h4>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Automates Decisions: Automatically approves or flags payments based on conditions like amount and document submission.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Saves Time: Eliminates manual checking for approval criteria.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Reduces Errors: Ensures consistent and accurate approvals by applying the same logic to all payments.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Dynamic Updates: Automatically adjusts results when payment data or document status changes.<\/span><\/li>\n<\/ul>\n<h2><span style=\"font-weight: 400;\">Simplify your workflows with IFs<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">The IFS formula is a game-changer for handling multiple conditions in Google Sheets. Whether you\u2019re managing inventory, tracking sales, or calculating hours, it eliminates complexity and enhances productivity.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Have a unique use case for the IFS formula? Share it in the comments\u2014we\u2019d love to hear your ideas!<\/span><\/p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]\n","protected":false},"excerpt":{"rendered":"<p>The IFS formula in Google Sheets is ideal for evaluating multiple conditions in a single formula. Whether tracking stock levels, managing sales data, or handling inventory, this formula simplifies complex logical operations and ensures efficient decision-making.\u00a0 Let\u2019s explore how the IFS formula works and highlight its practical applications with real-life examples.IFS formula syntax The IFS [&hellip;]<\/p>\n","protected":false},"author":46,"featured_media":44470,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[],"class_list":["post-51810","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-formulas"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/51810","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/46"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=51810"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/51810\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/44470"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=51810"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=51810"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=51810"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}