Announcement

Collapse
No announcement yet.

Using logical AND Conditional for Visibility.

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Using logical AND Conditional for Visibility.

    Dear All,

    I am trying to use AND conditional option for Visibility parameters.

    Problem: - I want show view panel in single & Double Door category but notevery door. if two parameters give corrects values then only visibilityparameters should show panel visibility.

    Please find below example: -

    if Door Width = 1800 then 2 View panel visibility show. (But it will be basedon 2 different parameters values)

    If Door Width = 1100 then 1 View Panel visibility show.

    I’m just exploring option. I don’t know my question is appropriateor not.
    If it’s work then it will be gr8 for me.


    Thanks
    Prashant Palande

    #2
    Panel 1 - yes/no check box (in case you want no vision panel)
    Panel 2 - yes/no checkbox with formula = length > 1100
    There are no stupid questions, only stupid people

    Comment


      #3
      DearWilliams

      Thank you for your prompt reply & your valuable time.

      You gave me correct formula, but I want to add one more true value. (It meansbased on 2 true values view panel should be appear.


      Please findbelow example: -


      if(and(DoorWidth=1800,Door Type=1, Door Flap=0)No ,No)
      if(and(DoorWidth=1800,Door Type=1,Door Flap=1)Yes ,No)
      if(and(DoorWidth=1800,Door Type=2, Door Flap=2)Yes ,No)
      if(and(DoorWidth=1800,Door Type=2, Door Flap=0)No ,No)

      Thanks
      PrashantPalande

      Comment


        #4
        You are very welcome. As far as i know you cant use if statements in a yes/no formula. But this blog by steve stafford will help you do what you want. There is also a thread on this forum discussing the procedure (link in the blog post).
        Revit OpEd: Setting Yes No Parameters with Formulas
        There are no stupid questions, only stupid people

        Comment


          #5
          Thanks Williams,

          it's really very good blog, Let me try as per blog options.

          Thank you very Much :thumbsup: :beer:

          Comment


            #6
            Originally posted by elton williams View Post
            You are very welcome. As far as i know you cant use if statements in a yes/no formula
            Of course you can... you just don't write the text result... you write the formula equivalent:
            Yes = True = 1>0
            No = False = 0>0

            So:
            =if(and(DoorWidth=1800,Door Type=1,Door Flap=0),0>1,0>1)
            =if(and(DoorWidth=1800,Door Type=1,Door Flap=1),1>0,0>1)
            etc

            Comment


              #7
              Originally posted by snowyweston View Post
              Of course you can... you just don't write the text result... you write the formula equivalent:
              Yes = True = 1>0
              No = False = 0>0

              So:
              =if(and(DoorWidth=1800,Door Type=1,Door Flap=0),0>1,0>1)
              =if(and(DoorWidth=1800,Door Type=1,Door Flap=1),1>0,0>1)
              etc
              My attempts have always failed lol. Im gonna try that first thing tomorrow .
              There are no stupid questions, only stupid people

              Comment


                #8
                Originally posted by snowyweston View Post
                Of course you can... you just don't write the text result... you write the formula equivalent:
                Yes = True = 1>0
                No = False = 0>0

                So:
                =if(and(DoorWidth=1800,Door Type=1,Door Flap=0),0>1,0>1)
                =if(and(DoorWidth=1800,Door Type=1,Door Flap=1),1>0,0>1)
                etc
                Of course you can, but why would you? I don't see it necessary except in cases of a massive formula with multiple checks.
                Last edited by Andrew K; August 30, 2017, 06:30 PM.
                Developer at Anguleris BIMsmith Marketplace.
                Previously at Sumex Design for ARCAT.com

                Comment


                  #9
                  Originally posted by snowyweston View Post
                  Of course you can... you just don't write the text result... you write the formula equivalent:
                  Yes = True = 1>0
                  No = False = 0>0

                  So:
                  =if(and(DoorWidth=1800,Door Type=1,Door Flap=0),0>1,0>1)
                  =if(and(DoorWidth=1800,Door Type=1,Door Flap=1),1>0,0>1)
                  etc
                  You don't even need to write out that much. The yes/no parameter is an automatic if/then statement because it's binary. Boolean operators return true/false results as well.


                  Those 2 statements can be shortened to this:
                  =and(DoorWidth=1800,Door Type=1,Door Flap=0)
                  =and(DoorWidth=1800,Door Type=1,Door Flap=1)

                  Comment


                    #10
                    TBF I didn't even read the OP, only Elton's assertion (that I wished to correct) and simply copy/pasted the formula given...

                    Comment

                    Related Topics

                    Collapse

                    Working...
                    X