Help & Support ↗ Lucanet Learning Space ↗
Getting Started
Global Functions
Administration
Extended Planning & Analysis (xP&A)
xP&A Video Tutorials
User Roles in Lucanet xP&A
Lucanet xP&A User Interface
All Steps at a Glance
Basic Concepts and Elements
Creating a Model
Integrating Data
Modeling Your Data
Creating and Editing Variables
Creating and Editing Formulas
Helper Variables
Variable Modifiers
IF Statements in Formulas
Functions for Formulas
Common Formulas
Troubleshooting
Values with Uncertainty
Working with Time
Using Dimensions
Using Currency and Currency Translation
Viewing and Visualizing Data
Working with Models
Using Comments and Descriptions
Comparison: xP&A vs. Excel Performance
Consolidation & Financial Planning
ESG Reporting
Disclosure Management
XBRL Tagger
Lease Accounting
Banking & Cash Management
Data Collection
Tax Compliance & Reporting
Glossary

If Statements in Formulas

Overview

When you want a variable to have different values or formulas based on a condition, you can use if statements. They always have to follow the structure if condition then X else Y.

Options in IF Statements

You can link multiple conditions with and and/or or:

  • if condition1 or condition2 then value1 else value2
  • if condition1 and condition2 then value1 else value2

You can also link conditions with a list using the syntax IN, for example:

  • if month in [11, 12, 1, 2] then 90% else 100%: means if the month is Nov, Dec, Jan or Feb, return 90% else return 100%.
  • You can also use dimensions/dimension items in if-statements, for more information, see Dimension Items in Formulas.

You can also link conditions with the exclusion of a list using the syntax NOT IN, for example:

  • if month not in [11, 12, 1, 2] then 90% else 100%: means if the month isn't Nov, Dec, Jan or Feb, return 90%, if it is return 100%.

You can have multiple layers of if statements too, for example:

  • if condition1 then value 1 else if condition2 then value2 else [...]
    \
  • You can break each of these layers out onto separate lines of your formula editor using Shift + Enter.
  • Note that every if statement must have an else, otherwise xP&A will return an error.

Examples of IF Statements

  • if timestep > 4 then 1 else 0
  • if variable1 > variable2 then 100 else 200
  • if timestep > 4 and timestep < 10 then 1 else 0
  • if variable1 < 10 then 100 else if variable1 < 20 then 200 else 300

Last updated on Aug 16, 2023

Table of Contents
If Statements in FormulasOverviewOptions in IF StatementsExamples of IF Statements
Related Articles

Company

Legal Notice

© Copyright 2026 - Lucanet AG