Notification

This Help Center is moving to Cloud. Learn more about the migration.

IF

Returns a value based on a conditional expression.

IF defines a condition and returns a result when that condition is met, or returns a different result if that condition is not met.

Note: IF is similar to CASE but acts only on a single condition, and can return only one true result or one false result.

Sample usage

Calculate a bonus rate if actual sales exceed forecast sales:

IF(Actual > Forecast, Bonus *1.2, Bonus)

Syntax

IF(condition, true_result, false_result)

Parameters

  • condition - The expression to evaluate. condition can be any valid Boolean expression.
  • true_result - the value to return if condition is true. true_result can be any valid expression.
  • false_result - the value to return if condition is false. false_result can be any valid expression.

Examples

Return a dimension based on a parameter selection.

For example, you can create a Boolean parameter, Forecast Parameter, and use it to return a column of forecasted data. Otherwise, use the actual data:

IF(Forecast Parameter, Forecast Data, Actual Data)

Identify records that are older than a certain number of days before today:

IF(DATETIME_DIFF(TODAY(), Date, DAY) > 60, "old","new")

A more complex condition with logical AND, and regular expression matching:

IF(Event name = "purchase" AND (REGEXP_MATCH(Page path, ".*footwear.*") OR REGEXP_MATCH(Page path, ".*shoes.*")), "Shoe Sales", Page title)
IF is limited to returning only one of two possible results: the true_result or the false_result. To create a function that can return more possible results, use CASE or simple CASE instead.

Was this helpful?

How can we improve it?
true
What's new in Looker Studio?

Learn about new features and recent changes. Looker Studio release notes live on Google Cloud.

Search
Clear search
Close search
Google apps
Main menu
1567363277111191278
true
Search Help Center
true
true
true
true
true
102097
false
false