# Conditions

Conditions are expressions you define to control calculations.

These are the key concepts to understand when working with conditions in Decipad:

• Booleans : Booleans represent pairs of data with values of `true` or `false`. They are used to define conditions and make decisions in your code. Booleans can also be the result of a comparison or logical operations.

• Comparison Operators: Comparison operators allow you to compare values and return a boolean value (`true` or `false`) based on the result of the comparison. Common comparison operators include:

• Greater than `>`
• Less than `<`
• Greater or equal than `>=`
• Less or equal than `<=`
• Equal to `==`
• Different to `!=`

Example: For a `Price = \$200` the condition `Price > \$100` is true, however, if `Price` is `\$300` the condition is false.

• Logical Operators: Logical operators enable you to combine and manipulate boolean values. The `not` operator negates a boolean value, `and` returns `true` if both operands are true, and `or` returns `true` if at least one operand is true.

Example: `TotalSales < \$500 and Discount > 5%`.

Combining comparison and logical operators allows you to create conditions that evaluate to either `true` or `false`. They can be used to control your calculations based on their outcome,

## If-Then-Else Conditions​

Syntax

` if [Condition] then [Calculation when Condition is True] else [Calculation when Condition is False]`

The `if [Condition] then ... else ...` statement lets you to create calculations conditionally. It takes your condition, check wether it is true or false, and performs a calculation based on that.

Examples

Let's consider a scenario where we have a condition `Item > \$200` . We want to determine if a certain item is overpriced or underpriced.

`if Item > \$200 then "Overpriced" else "Underpriced"`

In this example, the condition `Item > \$200` is evaluated. If it is `true`, the value "Overpriced" is returned; otherwise, the value "Underpriced" is returned. It's important to ensure that the expressions in the "then" and "else" parts return the same data type. Mixing different types can lead to errors.

Additionally, in tables, you can use the keyword `first` with the If-Then-Else statement to check for the first row.

Examples

Showcase a different message on the first row:
`if first then "I am the first row" else "I am not the first row"`

Compute income increases based on a set value from a slider:
`if first then IncomeSlider else previous(0) + 5%`

## Verification Conditions​

Syntax

`assert([Condition])`

To ensure that certain conditions are met on your notebook, you can use the `assert()` statement. It checks a condition and creates an error in the notebook if the condition is not true. This helps in validating assumptions and catching errors.

Examples

`assert(Sales >= \$0)`

If `Sales < \$0` an error will be generated, highlighting any discrepancy on your notebook.

## Checking Multiple Conditions​

Syntax
``[Result] = match {  [Condition 1]: [Result 1]  [Condition 2]: [Result 2]  [Condition 3]: [Result 3]              ...}``

The `match{}` statement tests a group of conditions and returns a value when a true statement is found. It simplifies decision-making based on specific conditions.

Examples

Suppose we have a variable `Performance` with the value "Exceeds". We want to determine the bonus based on the performance level.

In this example, the `Bonus` variable will be assigned the value of 2% because the value of `Performance` matches the condition "Exceeds". The `match()` statement allows us to specify different conditions and their corresponding results or calculations.

## Calculating Tiers​

Syntax
``tiers [Your Value] {         [Tier 1]: [Value or Calculation]         [Tier 2]: [Value or Calculation]         [Tier 3]: [Value or Calculation]                            ...  [Optional] rest: [Value or Calculation]  [Optional]  max: [Value or Calculation]  [Optional]  min: [Value or Calculation]}``

Tiers allow you to slice a number into different levels and perform calculations on each tier. It simplifies complex scenarios such as tiered sales commission structures or progressive tax systems.

Examples

Let's consider a sales commission scenario where the commission rate varies based on the sales amount (`YourSales`).

In this example, the `YourSales` variable is divided into different tiers based on the specified thresholds. The commission percentage changes as the sales amount crosses these thresholds. The `tiers` statement allows us to define calculations for each tier and handle scenarios beyond the defined thresholds.

### Reusing Tiers with a Custom Function​

To make tier calculations more reusable, you can define a custom formula that incorporates the tiers.

Examples

In this example, the `CalculateSales` formula takes the `YourSales` variable as input and applies the tiered calculation defined in the `tiers` formula. This allows you to easily calculate sales based on different sales amounts by using the `CalculateSales()` formula.

By calling `CalculateSales(\$120000)`, you will get the result based on the tiered calculations for that specific sales amount.