Table of Contents
The IFS function is a useful tool in Google Sheets that allows users to specify multiple conditions and corresponding results within a single formula. This function is particularly helpful for organizing and analyzing data by providing a simplified way to write complex logical statements. To use the IFS function, users must first designate the conditions and desired results, followed by the “IFS” keyword and the range of cells to evaluate. This function is useful for a variety of tasks, such as categorizing data, creating conditional formatting, and performing calculations based on specific criteria. By utilizing the IFS function, users can efficiently manage and analyze data in their Google Sheets documents.
IFS function
Evaluates multiple conditions and returns a value that corresponds to the first true condition.
Sample Usage
IFS(A1>90, "A", A1>80, "B", A1>70, "C")
IFS({A1:A5} > 3, "bigger", {A1:A5} = 3, "equal")
Syntax
IFS(condition1, value1, [condition2, value2, …])
condition1– The first condition to be evaluated. This can be a boolean, a number, an array, or a reference to any of those.value1– The returned value ifcondition1isTRUE.condition2, value2, …– Additional conditions and values if the first one is evaluated to be false.
Notes
- If all conditions are FALSE, #N/A is returned.
See Also
IF: Returns one value if a logical expression is `TRUE` and another if it is `FALSE`.
SWITCH:
Tests an expression against a list of cases and returns the corresponding value of the first matching case, with an optional default value if nothing else is met.
MAXIFS:
Returns the maximum value in a range of cells, filtered by a set of criteria.
MINIFS:
Returns the minimum value in a range of cells, filtered by a set of criteria.
Examples
| A | B | C | |
|---|---|---|---|
| 1 | Score | Grade | Formula |
| 2 | 88 | B | =IFS(A2 > 90, “A”, A2 > 80, “B”) |
| 3 | 92 | A | =IFS(A3 > 90, “A”, A3 > 80, “B”) |
| 4 | 65 | #N/A | =IFS(A4 > 90, “A”, A4 > 80, “B”) |
Cite this article
stats writer (2024). How can I use the IFS function in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-use-the-ifs-function-in-google-sheets/
stats writer. "How can I use the IFS function in Google Sheets?." PSYCHOLOGICAL SCALES, 29 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-use-the-ifs-function-in-google-sheets/.
stats writer. "How can I use the IFS function in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-use-the-ifs-function-in-google-sheets/.
stats writer (2024) 'How can I use the IFS function in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-use-the-ifs-function-in-google-sheets/.
[1] stats writer, "How can I use the IFS function in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I use the IFS function in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.