Google Sheets | IF | IFS | Function | What are the Differences | Example | Spreadsheet | Tutorial

In Google Sheets, the IF and IFS functions check whether a logical expression or condition is TRUE or FALSE. So, what are the differences between IF and IFS? IF allows only one logical expression, and returns one of the two values, corresponding to the TRUE or FALSE value. IFS allows multiple conditions, and returns the value corresponding to the first condition that evaluates to TRUE.
For more info on IF and IFS functions, please refer to their exclusive, step-by-step tutorials whose links are given below.
-------------------------------------
How to Use IFS in Google Sheets?
IFS allow multiple logical expressions:
• Google Sheets IFS | Te...
-------------------------------------
How to Use IF in Google Sheets?
Use IF to compare one value with another:
• Google Sheets IF | Tut...
-------------------------------------
How to Use IF with AND in Google Sheets?
Use IF with AND to Use Multiple Logical Expressions in IF:
• Google Sheets | IF | A...
-------------------------------------
How to Create a Pivot Table in Google Sheets?
Create a pivot table for calculation and in-depth data analysis:
• Google Sheets | Pivot ...
-------------------------------------
Which one to Use? A Pivot Table, or COUNTBLANK Function, to Count Blank Cells in Google Sheets:
Gives steps to use a pivot table or COUNTBLANK to count blank cells:
• Google Sheets | Pivot ...
-------------------------------------
How to Use a Pivot Table to Sum by Rows or Columns without using Formula in Google Sheets?
Sum numbers by rows and or columns easily, using a pivot table:
• Google Sheets | Pivot ...
-------------------------------------
How to Create a Pivot Table to Get Maximum Value without Using Formula in Google Sheets?
A pivot table assists to get the maximum value in a data range without using a formula:
• Google Sheets | Pivot ...
-------------------------------------
Let's take a look at the format of the IF function formula:
=IF(logical_expression, value_if_true, value_if_false)
The format of the IFS function formula is:
=IFS(condition1, value1, [condition2, …], [value2, …])
Note that IF allows only one logical expression, whereas IFS allows multiple
conditions.
IF returns the value assigned to value_if_true, if the logical expression
evaluates to true. Else, it returns the value assigned to value_if_false.
IFS returns the value corresponding to the first condition that evaluates to true.
Here are examples of IF and IFS functions.
IF Function
Example
=IF(C3=300, "Low Inventory", "---")
If the value in cell c3 is equal to 300, IF returns the text Low Inventory. Else, it returns three dashes.
IFS Function
Example
=IFS(Size="small", 348, Size="medium", 471, Size="large", 589)
Assume that a range of cells, pertaining to shirt sizes is named as Size.
The IFS function formula assigns a different value, based on if the shirt size is small, medium, or large.
Take a look at this video tutorial, which highlights the differences between the Google Sheets IF and IFS functions, with examples.