LiveFlow raises $13.5 million Series A led by New York-based Valar Ventures and launches LiveFlow Next to revolutionize accounting!
Read More
Arrow
Back to guides
Google Sheets Formulas

How to Use IFS Function in Google Sheets

In this article, you will learn how to utilize the IFS function in Google Sheets.

This function is helpful when you set up multiple conditions and corresponding returns (e.g., giving Grade A through E depending on if a score meets a criterion of each grade)

How to use the IFS formula in Google Sheets

  • Type “=IFS(” or go to “Insert”“Function”“Logical”“IFS”

  • Insert pairs of a condition and a return (when the condition is met) until you incorporate all conditions

  • Press the “Enter” key

How to Use IFS Function in Google Sheets
How to insert the IFS formula from the menu bar

Generic formula

=IFS(condition1, value1, [condition2, …], [value2, …])

Condition1: This is a standard to test a given value.

Value1: This is the value returned by the IFS formula when Condition1 is met.

Why spend hours creating spreadsheets, when we have already done the work for you?
100+ financial spreadsheet templates, all free and ready for you now.
Free Spreadsheet Templates

Imagine you are a general manager of a sales team and need to evaluate the performance of each member. Your company has a 5-level grade system for sales performance. The upper table, Evaluation Criteria, in the picture summarizes the grading system.

A tested number is given;


Grade A+ when equal to or more than 1,200;


Grade A when equal to or more than 900;


Grade B when equal to or more than 600;


Grade C when equal to or more than 300, and


Grade D when equal to or more than zero.

use the IFS function in Google Sheets with an example
How to use the IFS function in Google Sheets with an example

In Sales Team Performance with IFS function table, you can see the grades returned by the formulas, and each grade satisfies each criterion. The IFS formulas in Column D next to the Sales Amount test the Sales Amounts and drop them to the right place.

For instance, 200 by Tiger is more than 0 but less than 300; Tiger’s Grade is, unfortunately, D. 

 

What is the difference between IF and IFS in Google Sheets?

Look at the picture below. You can use the IF formula as an alternative to the IFS function by combining the IF formulas repeatedly in one IF formula. However, as you can see, the IFS function is shorter, easy to follow, and more visible, compared to the combination of the IF functions.

\The repetitive usage of IF formulas tends to look complicated because of many parentheses, and you often get lost while working the formula. We recommend that you use the IFS function when you need to set up a series of criteria and get the values returned according to the requirements.

comparison of the IF function and the IFS function with examples
A comparison of the IF function and the IFS function with examples

Turn Quickbooks Online data into a Google Sheets dashboard
100+ templates, update automatically, totally secure!
Book a Demo

Learn how to do this step-by-step in the video below 👇

Automate financial reporting with LiveFlow

Cta Photo

Want to eliminate manual updates of your Excel & Google Sheets models?

Yes, show me how!

Get personal help

We guarantee you personal help on chat or Zoom within maximum 6 hours between 9am and 10pm EST.
Blue Tick
Email us at: [email protected]

Liked this article? Then you'll love the ones below

Supercharge your financial reporting today

See LiveFlow in action and discover how to streamline your workflows.