Sometimes you want to translate a true/false boolean condition into an
equivalent text message. This is simple with just one true/false value:
TruthMessage := @If( Booleanvalue ; "True message" ; "False message")
But how do you handle multiple boolean values that combine in multiple ways?
For example, a pair of Boolean variables, NorthBool and SouthBool, give rise to
four possible messages, depending on whether both are True, both are False,
NorthBool only is true, or SouthBool only is true. Without using a complex nest
of @If functions, the following formula code produces an appropriate message
for each combination. It is generic and can be used for multiple Boolean
Choices := "Neither":"North Only":"South Only":"Both";
Index := ?SouthBool*2 + NorthBool + 1;
TruthMessage := @Subset(@Subset(Choices;Index); -1)
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.