Using an OR() Formula

[gemisic]

Hello,

I'm a beginner when it comes to using formulas. This is my first time using a formula with conditions. Im looking to display a message when employee's reach our milestone years of service to the company. I know Im close, but its not working. Can someone tell me what am I doing wrong here? Here is my formula:

IF(

  OR(

    {Working Years} = 1

    {Working Years} = 3

    {Working Years} = 5

    {Working Years} = 7

    {Working Years} = 10

  ),

  "🎉 Announce on Social Media")

[pressGO_design · Accepted solution]

You need commas between your working years inside your OR statement. 

OR(

    {Working Years} = 1, 

    {Working Years} = 3,

    {Working Years} = 5,

    {Working Years} = 7,

    {Working Years} = 10

  ),

[gemisic]

Ahhh yes! (duh)

It worked! Thank you very much. 😃