Skip to main content

​
if

Returns one of two values based on a condition.
Example:
The three arguments are:
  1. A condition
  2. The result when the condition is true
  3. The result when the condition is false
The two result expressions should represent compatible types. You can nest if calls:
For several categories or exceptions, a dimension-based formula may be easier to maintain than a deeply nested expression.

​
iferror

Returns the first expression when it succeeds, or the fallback when that expression produces a calculation error.
For example:
If Revenue is zero, the division creates a cell-level error and iferror returns 0 instead. You can also use it with date calculations: