Google Sheets

Google Sheets IF Statement

Use the IF statement in Google Sheets to return different values based on a condition, with practical examples for statuses, dates, and review flags.

June 12, 2026/5 min read

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

=IF(logical_expression, value_if_true, value_if_false)

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:

=IF(D2="Done","Complete","Open")

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:

=IF(D2>C2,"Over budget","On track")

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(C2<=TODAY()+7,"Due soon","Later")

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

=IF(C2="","","Due soon")

WATCH OUT

The blank-check formula above only checks whether the date cell is empty. It does not test whether the date is actually within seven days.

Use a combined condition when both rules matter:

=IF(AND(C2<>"",C2<=TODAY()+7),"Due soon","Later")

Use IF with AND or OR

Use AND when every condition must be true:

=IF(AND(D2="Approved",E2<=TODAY()+7),"Ready","Review")

Use OR when any condition can be true:

=IF(OR(D2="Blocked",D2="At risk"),"Needs attention","OK")

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

Common IF mistakes

Mistake	What happens	Fix
Text values are not in quotes	Formula error or wrong result	Use `"Approved"` not `Approved`
Date cells are blank	Blank rows get flagged	Check for blanks first
Too many nested IFs	Formula becomes hard to audit	Use `IFS` or a lookup table
Comparing text numbers	Results look inconsistent	Convert source values to numbers

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.

Skip the manual work

Describe it. Griddy does it.

Instead of writing this formula yourself, just tell Griddy what you need in plain English. Works in Excel and Google Sheets.

Excel Plugin Sheets Plugin

Use this on real templates

Turn rules into clear review labels

IF formulas help templates show status, budget, due-date, and approval flags without forcing reviewers to inspect every raw input.

Project Management

All posts