Skip to Content

If and elseif

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Oct 27, 2015 at 08:37 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 27, 2015 at 08:40 AM

    Hi Daniel,

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 27, 2015 at 09:02 AM

    Thanks a lot both of you 😊

    Add comment
    10|10000 characters needed characters exceeded