Formula Challenge

[kyleGDL86]

I'd like to create a formula for the following statement for a Height Control parameter:

If glass thickness is 1/4" then the  maximum height is 30" and if glass thickness is 1/2" then the maximum height is 20".

I can only get it to equal 20 or 30 in the family with the formula I am putting in, but in reality the glass height can be anything less than 20 or 30 depending on the glass thickness.

If my "Input" params are "Glass Thickness" AND "Height", am I overloading the formula?

[_Vijay]

@kyleGDL86  Hope below link will help..if not let me know I am happy to help you.

https://knowledge.autodesk.com/support/revit-products/learn-explore/caas/CloudHelp/cloudhelp/2014/EN... 

[L.Maas · Accepted solution]

How does your formula look so far and which parameters do you have in the family?

Maybe share the family (or a screenshot).

What if glass thickness i sneither 1/4"or 1/2"?

But something like this might do. You need three parameters

max_height: max height allowed

user_set_height: The desired height set by the user
height: the actual height of the window if allowed the desired height otherwise the max height

max_height parameter : If (glass thickness =  1/4, 30, If (glass thickness =  1/2, 20, 30))

user_set_height parameter: =40"

height parameter: if(user_set_height > max_height, max_height, user_set_height)

[martijn_pater]

Think I would use one more and with some yes/no parameters, assuming the glass will be either 1/2 or 1/4" depending on the height... But you can also use another IF statement I guess with three parameters. Or did you want to be able to adjust/input a glass thickness seperately aswell?

formula example

[kyleGDL86]

Thank you so much you nailed it. In this case the glass could only be those 2 thicknesses so your formulas worked perfectly. I had only gotten as far as the Max Height parameter but adding the Height parameter (by your definition) is what I couldn't figure out. Thanks again!