Skip to main content

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")

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
  ),

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
  ),

Ahhh yes! (duh)

It worked! Thank you very much. 😃

Reply


Terms & Conditions