{"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>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<\/p>\n<p>Let\u2019s explore how the IFS formula works and highlight its practical applications with real-life examples.<\/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>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.<\/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>=IFS(condition1, value_if_true1, [condition2, value_if_true2], \u2026)<\/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><b>condition1<\/b>: The first condition to test.<\/li>\n<li><b>value_if_true1<\/b>: The value to return if condition1 is TRUE.<\/li>\n<li><b>condition2<\/b>, <b>value_if_true2<\/b>, etc.: Additional conditions and their respective results.<\/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>Eliminates the need for cumbersome nested IF formulas.<\/li>\n<li>Handles multiple conditions with clarity and precision.<\/li>\n<li>Offers flexible, dynamic logic for advanced calculations.<\/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>Scenario: Calculate stock status based on specific thresholds.<\/p>\n<table>\n<tbody>\n<tr>\n<td>\n<p>A<\/p>\n<\/td>\n<td>\n<p>B<\/p>\n<\/td>\n<td>\n<p>C<\/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>Product A<\/p>\n<\/td>\n<td>\n<p>5<\/p>\n<\/td>\n<td>\n<p>Reorder Soon<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>Product B<\/p>\n<\/td>\n<td>\n<p>0<\/p>\n<\/td>\n<td>\n<p>Out of Stock<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>Product C<\/p>\n<\/td>\n<td>\n<p>50<\/p>\n<\/td>\n<td>\n<p>In Stock<\/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>=IFS(B5=0, &#8220;Out of Stock&#8221;, B5&lt;10, &#8220;Reorder Soon&#8221;, B5&gt;=10, &#8220;In Stock&#8221;)<\/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><b>Condition 1: <\/b>B5=0, &#8220;Out of Stock&#8221;\n<ul>\n<li>If the value in B5 is exactly <b>0<\/b>, the formula returns <b>&#8220;Out of Stock&#8221;<\/b>.<\/li>\n<\/ul>\n<\/li>\n<li><b>Condition 2: <\/b>B5&lt;10, &#8220;Reorder Soon&#8221;\n<ul>\n<li>If the value in B5 is less than <b>10<\/b> (but not 0), the formula returns <b>&#8220;Reorder Soon&#8221;<\/b>.<\/li>\n<\/ul>\n<\/li>\n<li><b>Condition 3: <\/b>B5&gt;=10, &#8220;In Stock&#8221;\n<ul>\n<li>If the value in B5 is greater than or equal to <b>10<\/b>, the formula returns <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>How it works:<\/h4>\n<ul>\n<li>If the stock level is 0, it returns <b>&#8220;Out of Stock&#8221;<\/b>.<\/li>\n<li>If the stock level is less than 10, it returns <b>&#8220;Reorder Soon&#8221;<\/b>.<\/li>\n<li>Otherwise, it returns <b>&#8220;In Stock&#8221;<\/b>.<\/li>\n<\/ul>\n<h4>Benefits:<\/h4>\n<ul>\n<li>Automatically tracks stock status without manual intervention.<\/li>\n<li>Helps in maintaining optimal inventory levels.<\/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>2. Stage-Wise Sales Breakup<\/h3>\n<p>Scenario: Categorize sales leads based on their status.<\/p>\n<table>\n<tbody>\n<tr>\n<td>\n<p>A<\/p>\n<\/td>\n<td>\n<p>B<\/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>Target<\/p>\n<\/td>\n<td>\n<p>Initial<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>Contract Generated<\/p>\n<\/td>\n<td>\n<p>Negotiation<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>Lost<\/p>\n<\/td>\n<td>\n<p>Closed &#8211; Lost<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>Won<\/p>\n<\/td>\n<td>\n<p>Closed &#8211; Won<\/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>=IFS(A5=&#8221;Target&#8221;, &#8220;Initial&#8221;, A5=&#8221;Contract Generated&#8221;, &#8220;Negotiation&#8221;, A5=&#8221;Lost&#8221;, &#8220;Closed &#8211; Lost&#8221;, A5=&#8221;Won&#8221;, &#8220;Closed &#8211; Won&#8221;)<\/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><b>Condition 1: <\/b>A5=&#8221;Target&#8221;, &#8220;Initial&#8221;<\/li>\n<ul>\n<li>If the value in A5 is <b>&#8220;Target&#8221;<\/b>, the formula returns <b>&#8220;Initial&#8221;<\/b>.<\/li>\n<\/ul>\n<li><b>Condition 2: <\/b>A5=&#8221;Contract Generated&#8221;, &#8220;Negotiation&#8221;<\/li>\n<ul>\n<li>If the value in A5 is <b>&#8220;Contract Generated&#8221;<\/b>, the formula returns <b>&#8220;Negotiation&#8221;<\/b>.<\/li>\n<\/ul>\n<li><b>Condition 3: <\/b>A5=&#8221;Lost&#8221;, &#8220;Closed &#8211; Lost&#8221;<\/li>\n<ul>\n<li>If the value in A5 is <b>&#8220;Lost&#8221;<\/b>, the formula returns <b>&#8220;Closed &#8211; Lost&#8221;<\/b>.<\/li>\n<\/ul>\n<li><b>Condition 4: <\/b>A5=&#8221;Won&#8221;, &#8220;Closed &#8211; Won&#8221;<\/li>\n<ul>\n<li>If the value in A5 is <b>&#8220;Won&#8221;<\/b>, the formula returns <b>&#8220;Closed &#8211; Won&#8221;<\/b>.<\/li>\n<\/ul>\n<\/ul>\n<p><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><\/p>\n<h4>How it works<\/h4>\n<p>Matches the lead status with predefined stages and returns the corresponding stage.<\/p>\n<h4>Benefits<\/h4>\n<ul>\n<li>Provides dynamic categorization for leads, aiding in better sales tracking.<\/li>\n<li>Simplifies sales pipeline visualization.<\/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>3. Student Grading System Based on Scores<\/h3>\n<p>Scenario: A teacher wants to assign grades to students based on their test scores using specific criteria.<\/p>\n<table>\n<tbody>\n<tr>\n<td>\n<p>A<\/p>\n<\/td>\n<td>\n<p>B<\/p>\n<\/td>\n<td>\n<p>C<\/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>Alice Johnson<\/p>\n<\/td>\n<td>\n<p>85<\/p>\n<\/td>\n<td>\n<p>A<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>Bob Carter<\/p>\n<\/td>\n<td>\n<p>72<\/p>\n<\/td>\n<td>\n<p>B<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>Clara Lopez<\/p>\n<\/td>\n<td>\n<p>90<\/p>\n<\/td>\n<td>\n<p>A<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>David Brown<\/p>\n<\/td>\n<td>\n<p>65<\/p>\n<\/td>\n<td>\n<p>C<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>Emma White<\/p>\n<\/td>\n<td>\n<p>50<\/p>\n<\/td>\n<td>\n<p>D<\/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>=IFS(B5=&#8221;&#8221;, &#8220;Missing Data&#8221;, B5&gt;=85, &#8220;A&#8221;, B5&gt;=70, &#8220;B&#8221;, B5&gt;=60, &#8220;C&#8221;, B5&lt;60, &#8220;D&#8221;)<\/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><b>Condition 1:<\/b><\/li>\n<\/ul>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li><b>B5=&#8221;&#8221;<\/b><b>, <\/b><b>&#8220;Missing Data&#8221;<\/b><b>: <\/b>If the cell B5 is blank, the formula returns &#8220;Missing Data&#8221;.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li><b>Condition 2:<\/b><\/li>\n<\/ul>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li><b>B5&gt;=85, &#8220;A&#8221;<\/b><b>: <\/b>If the score is greater than or equal to 85, it returns &#8220;A&#8221;.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li><b>Condition 3:<\/b><\/li>\n<\/ul>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li><b>B5&gt;=70, &#8220;B&#8221;<\/b><b>: <\/b>If the score is greater than or equal to 70 but less than 85, it returns &#8220;B&#8221;.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li><b>Condition 4:<\/b><\/li>\n<\/ul>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li><b>B5&gt;=60, &#8220;C&#8221;<\/b><b>: <\/b>If the score is greater than or equal to 60 but less than 70, it returns &#8220;C&#8221;.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li><b>Condition 5:<\/b><\/li>\n<\/ul>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li><b>B5&lt;60, &#8220;D&#8221;<\/b><b>:<\/b> If the score is less than 60, it returns &#8220;D&#8221;.<\/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>Check out the formula in the spreadsheet<\/i><\/a><\/p>\n<h4>How it works<\/h4>\n<ul>\n<li>The formula starts by checking if <b>B5 is blank<\/b>. If true, it immediately returns <b>&#8220;Missing Data&#8221;<\/b> and stops further evaluation.<\/li>\n<li>If <b>B5 has a score<\/b>, it evaluates the score against the conditions in sequential order:<\/li>\n<ul>\n<li>If <b>B5 &gt;= 85<\/b>, it assigns <b>&#8220;A&#8221;<\/b>.<\/li>\n<li>If <b>B5 &gt;= 70<\/b>, it assigns <b>&#8220;B&#8221;<\/b> (only if the score doesn\u2019t qualify for &#8220;A&#8221;).<\/li>\n<li>If <b>B5 &gt;= 60<\/b>, it assigns <b>&#8220;C&#8221;<\/b> (only if the score doesn\u2019t qualify for &#8220;A&#8221; or &#8220;B&#8221;).<\/li>\n<li>If <b>B5 &lt; 60<\/b>, it assigns <b>&#8220;D&#8221;<\/b>.<\/li>\n<\/ul>\n<li>The <b>IFS<\/b> formula stops evaluating as soon as it finds a condition that is <b>TRUE<\/b>, ensuring efficiency.<\/li>\n<li>Handles missing data and assigns appropriate grades automatically, saving time and reducing errors.<\/li>\n<\/ul>\n<h4>Benefits<\/h4>\n<ul>\n<li><b>Simplifies Logic: <\/b>Eliminates the need for nested IF statements, making formulas easier to read and manage.<\/li>\n<li><b>Handles Multiple Conditions: <\/b>Efficiently evaluates multiple criteria in a single formula.<\/li>\n<li><b>Dynamic and Flexible: <\/b>Adapts to different scenarios like grading, approvals, or categorization.<\/li>\n<li><b>Improves Clarity: <\/b>Provides clear outputs based on logical conditions, enhancing data interpretation.<\/li>\n<li><b>Error-Free Execution: <\/b>Stops at the first TRUE condition, reducing unnecessary calculations.<\/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>4. Conditional Payment Approvals<\/h3>\n<p><b>Scenario:<\/b> A finance team wants to approve payments based on conditions such as payment amount and supporting documents.<\/p>\n<table>\n<tbody>\n<tr>\n<td>\n<p>A<\/p>\n<\/td>\n<td>\n<p>B<\/p>\n<\/td>\n<td>\n<p>C<\/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>Alice Johnson<\/p>\n<\/td>\n<td>\n<p>A<\/p>\n<\/td>\n<td>\n<p>95%<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>Ben Carter<\/p>\n<\/td>\n<td>\n<p>B+<\/p>\n<\/td>\n<td>\n<p>88%<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>Clara Lopez<\/p>\n<\/td>\n<td>\n<p>A-<\/p>\n<\/td>\n<td>\n<p>90%<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>David Brown<\/p>\n<\/td>\n<td>\n<p>B<\/p>\n<\/td>\n<td>\n<p>85%<\/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>=IFS(C5=&#8221;No&#8221;, &#8220;Pending&#8221;, AND(B5&lt;=1000, C5=&#8221;Yes&#8221;), &#8220;Approved&#8221;, AND(B5&gt;1000, C5=&#8221;Yes&#8221;), &#8220;Approved&#8221;, B5&gt;1000, &#8220;Pending&#8221;)<\/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><b>Condition 1<\/b>:<\/li>\n<ul>\n<li>C5=&#8221;No&#8221;, &#8220;Pending&#8221;: If the documents are not submitted (C5=&#8221;No&#8221;), the status is <b>&#8220;Pending&#8221;<\/b>.<\/li>\n<\/ul>\n<li><b>Condition 2<\/b>:<\/li>\n<ul>\n<li>AND(B5&lt;=1000, C5=&#8221;Yes&#8221;), &#8220;Approved&#8221;: If the payment amount is less than or equal to $1,000 and documents are submitted, the status is <b>&#8220;Approved&#8221;<\/b>.<\/li>\n<\/ul>\n<li><b>Condition 3<\/b>:<\/li>\n<ul>\n<li>AND(B5&gt;1000, C5=&#8221;Yes&#8221;), &#8220;Approved&#8221;: If the payment amount is greater than $1,000 and documents are submitted, the status is <b>&#8220;Approved&#8221;<\/b>.<\/li>\n<\/ul>\n<li><b>Condition 4<\/b>:<\/li>\n<ul>\n<li>B5&gt;1000, &#8220;Pending&#8221;: If the payment amount is greater than $1,000 but documents are not submitted, the status is <b>&#8220;Pending&#8221;<\/b>.<\/li>\n<\/ul>\n<\/ul>\n<p><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><\/p>\n<h4>How it works<\/h4>\n<ul>\n<li>Checks if the payment amount is missing and returns &#8220;Missing Data&#8221;.<\/li>\n<li>If documents are not submitted, it marks the payment as &#8220;Pending&#8221;.<\/li>\n<li>Approves payments if the amount is within the limit and documents are submitted.<\/li>\n<li>Marks large payments as &#8220;Pending&#8221; if documents are not provided.<\/li>\n<li>Stops checking once a condition is met and returns the result.<\/li>\n<\/ul>\n<h4>Benefits<\/h4>\n<ul>\n<li>Automates Decisions: Automatically approves or flags payments based on conditions like amount and document submission.<\/li>\n<li>Saves Time: Eliminates manual checking for approval criteria.<\/li>\n<li>Reduces Errors: Ensures consistent and accurate approvals by applying the same logic to all payments.<\/li>\n<li>Dynamic Updates: Automatically adjusts results when payment data or document status changes.<\/li>\n<\/ul>\n<h2>Simplify your workflows with IFs<\/h2>\n<p>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.<\/p>\n<p>Have a unique use case for the IFS formula? Share it in the comments\u2014we\u2019d love to hear your ideas!<\/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":[],"permalink_manager":null,"_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}]}}