Skip to main content
Solved

Using an OR() Formula

  • August 11, 2023
  • 2 replies
  • 18 views
G
Forum|alt.badge.img+4

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

Best answer by pressGO_design

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

2 replies

pressGO_design
Forum|alt.badge.img+21
  • pressGO_design
  • Brainy
  • 253 replies
  • Answer
  • August 11, 2023

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
  ),
G
Forum|alt.badge.img+4
  • gemisic
  • Author
  • New Participant
  • 1 reply
  • August 11, 2023

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


Terms & ConditionsAccessibility statement