Forum Discussion

RenPNW's avatar
RenPNW
Copper Contributor
Apr 12, 2024
Solved

how to add an OR statement to formula

Hi, Looking for some help on this formula: If(varTabSelected=1,(DataCardValue71.Selected.Value = "Diversion"),Or(DataCardValue72.Selected.Value = "Diversion"))   I have a column that I want to b...
  • ganeshsanap's avatar
    Apr 12, 2024

    RenPNW,

     

    Formula suggested by Rob_Elliott should work for you.

     

    However, And and Or function already returns true/false result. Hence, no need to use If function. Use shorter formula like: 

     

    varTabSelected=1 && (DataCardValue71.Selected.Value = "Diversion" || DataCardValue72.Selected.Value = "Diversion")

     

    OR 

     

    And(varTabSelected=1, Or(DataCardValue71.Selected.Value = "Diversion", DataCardValue72.Selected.Value = "Diversion"))

     


    Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.