Microsoft Visio "IF" function

Question

Hello, i don't understand how tow write several values in true/false section.

Trying to list several values with a sign ";" I get a formula error.

Example:

IF(LOOKUP(***,***.Format)="0", 10,30,99... , 28,33,76.... )

Answer 1

I found the solution myself. The function looks like this:

=IF(LOOKUP(Prop.***,Prop.***.Format)="0",User.1.Promt,User.2.Promt)

Thus, it turns out that if the IF function doesn't know how to make a list of true or false values, we make it ourselves and then refer to these lists.

Answer 2

Hi Alex,

I understand that you're having trouble using the "IF" function in Microsoft Visio, especially when trying to list several values in the true/false sections. But here we mainly focus on feature and issues, so to make sure you can get the appropriate guide on using the "IF" function in Visio, please post a new thread in Microsoft Q&A Community. Meanwhile, we will keep your thread open and welcome other community members and Visio MVPs to share their experience for you.

Meanwhile, below are some information I found online for your reference:

In Visio, the "IF" function syntax is: IF(logical_expression, value_if_true, value_if_false), which means that the function evaluates the logical_expression, and if it is true, it returns value_if_true; otherwise, it returns value_if_false.

However, Visio does not support listing multiple values separated by semicolons (;) within the value_if_true or value_if_false sections. Instead, you need to use nested "IF" functions or other logical functions to handle multiple conditions.

For example, if you want to check multiple conditions and return different values, you can nest "IF" functions like this:

IF(LOOKUP(***,***.Format)="0", 10, IF(LOOKUP(***,***.Format)="1", 30, IF(LOOKUP(***,***.Format)="2", 99, 28)))

In this example, if the LOOKUP function returns "0", the formula returns 10. If it returns "1", it returns 30. If it returns "2", it returns 99. Otherwise, it returns 28. If you need to handle more complex scenarios, you might need to use additional functions like AND, OR, or CHOOSE to manage multiple conditions and values.

Please let me know if there have anything else I can do for you. Hope you a nice day and stay safe!

Best Regards,

Mia