Google Sheets IF Statement

The IF statement in Google Sheets returns one value when a condition is true and another value when it is false. It is useful for status labels, review flags, approval checks, budget warnings, and any workflow where a sheet needs to make a simple decision.

Use IF when the logic has two clear outcomes. If the sheet needs many branches, move to IFS or a lookup table instead.

The syntax

• logical_expression - the test you want Sheets to evaluate
• value_if_true - what to return when the test passes
• value_if_false - what to return when the test fails

Basic status example

If a task is complete when column D says Done, return a cleaner review label:

This works well in a project tracker or content calendar where review meetings need consistent status labels.

Number comparison example

Say an expense is over budget when actual spend in D2 is greater than planned spend in C2:

That pattern is useful in small business budget and expense tracker workflows because it turns raw variance math into a readable flag.

Date example

To flag tasks due within the next seven days:

If blank dates should stay blank, add a blank check first:

Use a combined condition when both rules matter:

Use IF with AND or OR

Use AND when every condition must be true:

Use OR when any condition can be true:

These formulas are most useful when the sheet has to produce a single review label from several operating fields.

Common IF mistakes

Guard blanks and branch order

An IF formula can return a plausible answer for an empty row unless the blank case is handled first. For a due-date flag, use =IF(C2="","",IF(C2<=TODAY()+7,"Due soon","Later")). The outer check prevents blank cells from being treated as dates near the start of the calendar.

Use AND when every condition must be true and OR when any condition should trigger the result. For example, =IF(AND(D2="Approved",E2<=TODAY()+7),"Ready","Review") requires both approval and timing. When several thresholds are mutually exclusive, order them from most specific or highest priority to least specific; the first true branch wins.

If the logic grows beyond a few readable branches, use IFS, a lookup table, or helper columns. A shorter formula that another person can audit is usually safer than a deeply nested formula that hides the business rule.

Sources

• Google Docs Editors Help: IF function
• Google Docs Editors Help: Google Sheets function list

The Griddy way

IF formulas get messy when a simple status rule grows into a dozen exceptions.

"Add review flags to this project tracker: mark overdue approved work as urgent, blocked work as needs attention, and blank due dates as missing"

Griddy can translate the rule into spreadsheet logic, place the formula in the right column, and keep the labels consistent across the sheet.