Google Sheets | IF Function | When to Use | Example | Spreadsheet | Tutorial | Compare Values

The Google Sheets IF function is one of the most powerful functions. When to use this function? Use it when you want to compare a value in a cell with another value. For example, you can check if the value in, say, cell B12 is greater than, greater than or equal to, less than, less than or equal to, equal to, or not equal to another value, by creating a logical expression.
The logical expression evaluates to either TRUE or FALSE. You can specify a value for either case for IF to return.
For an exclusive tutorial on IF, please refer to the tutorial titled How to Use
IF in Google sheets, whose link is given below.
-------------------------------------
How to Use IF in Google Sheets?
Use IF to compare one value with another:
• Google Sheets IF | Tut...
-------------------------------------
How to Use FV in Google Sheets?
Calculate the future value of a present value:
• Google Sheets FV Funct...
-------------------------------------
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 ...
-------------------------------------
The format of the IF function formula is:
=IF(logical_expression, value_if_true, value_if_false)
logical_expression is an expression that should evaluate to either true or false.
value_if_true is the value that IF should return if logical_expression is true.
value_if_false is the value that IF should return if logical_expression is false.
Examples
Example 1
=IF(C3="Over due", "Send notice", "---")
Assume that the above IF function formula is typed in cell D3. If the value of cell C3 is the text Over due, then D3 will have the text Send notice. Else, it will be filled with three dashes.
Example 2
=IF(AND(B7=R37291, C7=0), "Order", "Don't Order")
The formula uses AND function to check whether the value in cell B7 is R37291 AND the value in cell C7 is 0. If true, the function returns the text Order. Else IF will return Don't Order.
Check out this video tutorial, which explains when to use the Google Sheets IF function, with examples.