Category

General-Purpose Functions

Description

Conditional choice function

Syntax

IF(condition, if_true, if_false)

Parameters

condition - formula specifying a true/false condition (non-zero means true)

if_true - formula to evaluate and return the result of if condition is true

if_false - formula to evaluate and return the result of if condition is false

Notes

Only one the two formulas gets evaluated, depending on the condition. The function returns the result of evaluating the selected formula.

This function can also be referred to as "IIF" if you prefer.

 

 

 

Copyright © 2020-2021 Systematic Solutions, LLC