Help

Re: Using an OR() Formula

Solved
Jump to Solution
1051 1
cancel
Showing results for 
Search instead for 
Did you mean: 
gemisic
4 - Data Explorer
4 - Data Explorer

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

Accepted Solutions
pressGO_design
10 - Mercury
10 - Mercury

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

See Solution in Thread

2 Replies 2
pressGO_design
10 - Mercury
10 - Mercury

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. 😃