Define list of integers in formula

Hi everyone

Does anyone here know how the syntax to make a list of numbers in formula (sorry for the bad english describtion: )

Lets say I need to make a formula that checks if the value in A1 is for a variable is either 1, 2, 3 or 4.

My best guess would be something like:

=If(A1=[1,2,3,4];"Yes";"No")

But of course it does not work : )

Can this be done without creating a named range?

Thanks
Kr
Morten

Try something like this:

=IF(OR(A1={1,2,3,4}),"Yes","No")

Originally Posted by 63falcondude

Try something like this:

=IF(OR(A1={1,2,3,4}),"Yes","No")

Thanks for the reply - it did not work with the "," seperation of integers but I replaced the "," with a ";" and it worked fine!

Thanks

Whoops, I should have noticed that our regional settings were different. Glad you were able to fix it.

Thanks for the rep!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.