If and elseif

[former_member962987]

Hi , is there a better way to create a formula if you for example wants to find certain numbers.

Right now, i am using If(Value =1 Then 1 Elseif Value =2 Then 1 Elseif, and so on, is there a better way to do it when you have multiple numbers?

[former_member201488 · Accepted solution]

=If [Value] inlist("1";"2") then 1 else....etc

[former_member962987]

Thanks a lot both of you

[Former Member]

Hi Daniel,