Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.anlytic.com/llms.txt

Use this file to discover all available pages before exploring further.

Returns Value 1 for every row where the first condition is met. If more than one condition is supplied, subsequent conditions are evaluated and return their corresponding values. If all conditions are False, then the Else value is applied. Category: logical Syntax: 
If(condition1, value1, [condition2], [value2], ..., [else])
Returns: AnyColumn Context Filtering: ✓ Yes

​
Parameters

NameTypeRequiredDescription
condition 1logical✓ YesLogical condition that returns a result that is either True or False.
value 1any✓ YesThe value to be returned if its preceding condition is True.
additional conditions and valuesvariadic✗ NoSeveral If/Then pairs can be listed in a single function. Every supplied condition must have a corresponding value.
elseany✗ NoThe value to be returned if no conditionals evaluate to True. If not specified, a Null result is returned by default.

​
Validation

  • Minimum parameters: 2
  • Maximum parameters: Unlimited

​
Examples

If([size] < 3, "small", [size] < 6, "medium", "large")
Assign “small” to sizes less than 3, “medium” to sizes less than 6, and “large” to all other sizes. 
If([revenue] - [cost] > 0, "profit", "loss")
Categorize a record as a profit or a loss based on revenue and cost.
  • Switch - Better for matching specific values
  • Between - Check if value is in a range
  • In - Check if value matches any in a list
Last modified on March 13, 2026