IF-THEN Formula in Google Sheets: Complete Guide with Examples | SheetXAI

The Problem

You need to automatically categorize or make decisions based on cell values. For example, marking sales as 'High' if they're above $1000, or calculating bonuses based on performance thresholds.

The Easy Way: Use SheetXAI

If you don't want to mess with formulas, the fastest way to do this is simply by asking.

With SheetXAI, you can open the sidebar and type:

Mark each sale as 'High' if the amount is greater than 1000, otherwise mark it as 'Low'.

SheetXAI will instantly write the formula or script for you and fill the cells. It handles the syntax so you can focus on the result.

The Manual Way: The Formulas You Need

To do this manually, you need to use: IF function.

1. IF

Returns one value if a condition is TRUE, and another value if the condition is FALSE. This is the foundation of conditional logic in Google Sheets.

Syntax: =IF(logical_test, value_if_true, value_if_false)

• logical_test: The condition you want to test (e.g., A2>1000).
• value_if_true: The value to return if the condition is TRUE.
• value_if_false: The value to return if the condition is FALSE.

Example: If A2 is greater than 1000, return 'High', otherwise return 'Low'.

Understanding the Logic

1. Test the condition: Check if the value meets your criteria (e.g., A2>1000).
2. If TRUE: Return the first value (e.g., 'High').
3. If FALSE: Return the second value (e.g., 'Low').

You can nest multiple IF functions for more complex conditions, or combine with AND/OR functions for multiple criteria.

The Final Formula:

=IF(A2>1000, 'High', 'Low')

Conclusion

Now you know the "classic" way to solve this using formulas. It's a great skill to have.

But for those times when you just want the job done without the mental math, SheetXAI is there to help.

Related Guides

• How to Write Nested IF Statements in Google Sheets - Learn to handle complex conditional logic
• How to Use VLOOKUP in Google Sheets - Look up and merge data from different sheets
• How to Count Cells in Google Sheets - Count cells based on conditions using COUNTIF
• Google Sheets AI Guide - Learn how AI can automate your Google Sheets workflows
• AI Spreadsheet Tools - Discover how AI transforms spreadsheet work