{"id":198642,"date":"2015-08-10T19:31:16","date_gmt":"2015-08-10T17:31:16","guid":{"rendered":"http:\/\/www.bim-me-up.com\/?p=198642"},"modified":"2019-02-04T13:59:25","modified_gmt":"2019-02-04T12:59:25","slug":"198642","status":"publish","type":"post","link":"https:\/\/bim-me-up.com\/en\/198642\/","title":{"rendered":"Formulas in the Revit family editor"},"content":{"rendered":"<p>You probably know that using formulas in the Revit family editor can add intelligence to your families - but do you know what you can do with formulas?<br \/>\nI stumbled across my \"cheat sheet\" of examples earlier, which I am happy to share with you:<\/p>\n<p><strong>Mathematical calculations:<\/strong><\/p>\n<p>Area = width * length<br \/>\nNumber of segments = length \/ segment length<br \/>\nc = sqrt(a*a+b*b)<em> (sqrt = square root)<\/em><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/bim-me-up.com\/wp-content\/uploads\/2015\/08\/Revit-Familieneditor-Formeln1-1.png\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"198644\" data-permalink=\"https:\/\/bim-me-up.com\/en\/198642\/revit-familieneditor-formeln-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/bim-me-up.com\/wp-content\/uploads\/2015\/08\/Revit-Familieneditor-Formeln1-1.png?fit=1235%2C452&amp;ssl=1\" data-orig-size=\"1235,452\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Revit-Familieneditor-Formeln\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/bim-me-up.com\/wp-content\/uploads\/2015\/08\/Revit-Familieneditor-Formeln1-1.png?fit=300%2C110&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/bim-me-up.com\/wp-content\/uploads\/2015\/08\/Revit-Familieneditor-Formeln1-1.png?fit=750%2C275&amp;ssl=1\" class=\"aligncenter wp-image-198644 size-large\" src=\"https:\/\/i0.wp.com\/bim-me-up.com\/wp-content\/uploads\/2015\/08\/Revit-Familieneditor-Formeln1-1-1024x375.png?resize=950%2C348\" alt=\"Revit family editor formulas\" width=\"950\" height=\"348\" srcset=\"https:\/\/i0.wp.com\/bim-me-up.com\/wp-content\/uploads\/2015\/08\/Revit-Familieneditor-Formeln1-1.png?resize=1024%2C375&amp;ssl=1 1024w, https:\/\/i0.wp.com\/bim-me-up.com\/wp-content\/uploads\/2015\/08\/Revit-Familieneditor-Formeln1-1.png?resize=300%2C110&amp;ssl=1 300w, https:\/\/i0.wp.com\/bim-me-up.com\/wp-content\/uploads\/2015\/08\/Revit-Familieneditor-Formeln1-1.png?resize=768%2C281&amp;ssl=1 768w, https:\/\/i0.wp.com\/bim-me-up.com\/wp-content\/uploads\/2015\/08\/Revit-Familieneditor-Formeln1-1.png?w=1235&amp;ssl=1 1235w\" sizes=\"auto, (max-width: 950px) 100vw, 950px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Dependencies:\u00a0<\/strong><!--more--><\/p>\n<p>if(number &lt; 2, <em>THEN condition, OTHER condition<\/em>)<br \/>\nnot(ParameterA) - boolean value, very useful for visibility parameters, returns true value for the parameter if ParameterA has a false value<\/p>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"198645\" data-permalink=\"https:\/\/bim-me-up.com\/en\/198642\/revit-family-editor-formulas-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/bim-me-up.com\/wp-content\/uploads\/2015\/08\/Revit-Familieneditor-Formeln2-1.png?fit=1171%2C587&amp;ssl=1\" data-orig-size=\"1171,587\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Revit-Familieneditor-Formeln2\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/bim-me-up.com\/wp-content\/uploads\/2015\/08\/Revit-Familieneditor-Formeln2-1.png?fit=300%2C150&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/bim-me-up.com\/wp-content\/uploads\/2015\/08\/Revit-Familieneditor-Formeln2-1.png?fit=750%2C376&amp;ssl=1\" class=\"aligncenter wp-image-198645 size-large\" src=\"https:\/\/i0.wp.com\/bim-me-up.com\/wp-content\/uploads\/2015\/08\/Revit-Familieneditor-Formeln2-1-1024x513.png?resize=950%2C476\" alt=\"Revit family editor formulas2\" width=\"950\" height=\"476\" srcset=\"https:\/\/i0.wp.com\/bim-me-up.com\/wp-content\/uploads\/2015\/08\/Revit-Familieneditor-Formeln2-1.png?resize=1024%2C513&amp;ssl=1 1024w, https:\/\/i0.wp.com\/bim-me-up.com\/wp-content\/uploads\/2015\/08\/Revit-Familieneditor-Formeln2-1.png?resize=300%2C150&amp;ssl=1 300w, https:\/\/i0.wp.com\/bim-me-up.com\/wp-content\/uploads\/2015\/08\/Revit-Familieneditor-Formeln2-1.png?resize=768%2C385&amp;ssl=1 768w, https:\/\/i0.wp.com\/bim-me-up.com\/wp-content\/uploads\/2015\/08\/Revit-Familieneditor-Formeln2-1.png?w=1171&amp;ssl=1 1171w\" sizes=\"auto, (max-width: 950px) 100vw, 950px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Rounds<\/strong><\/p>\n<p>You can also round all values directly in the family editor:<\/p>\n<p><span style=\"text-decoration: underline;\">round(x) <\/span>- rounds to the nearest integer without taking the sign into account.<\/p>\n<p><span style=\"text-decoration: underline;\">roundup(x)<\/span> - rounds to the next higher integer<\/p>\n<p><span style=\"text-decoration: underline;\">rounddown(x)<\/span> - rounds to the next lower integer<\/p>\n<p>&nbsp;<\/p>\n<p>Of course, there is much more possible - if you can think of another cool tip, then post it in the comments! \ud83d\ude42<\/p>\n<p>Have fun planning your family! \ud83d\ude09<\/p>","protected":false},"excerpt":{"rendered":"You probably know that using formulas in the Revit Family Editor can add intelligence to your families - but...","protected":false},"author":1,"featured_media":198643,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[7],"tags":[88,105,29,31],"class_list":{"0":"post-198642","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-revit","8":"tag-blog","9":"tag-deu","10":"tag-familieneditor","11":"tag-formeln","12":"cs-entry","13":"cs-video-wrap"},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/bim-me-up.com\/wp-content\/uploads\/2015\/08\/Revit-Familieneditor-Formeln-1.png?fit=1330%2C478&ssl=1","jetpack_shortlink":"https:\/\/wp.me\/s2lEa7-198642","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/bim-me-up.com\/en\/wp-json\/wp\/v2\/posts\/198642","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bim-me-up.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bim-me-up.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bim-me-up.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bim-me-up.com\/en\/wp-json\/wp\/v2\/comments?post=198642"}],"version-history":[{"count":2,"href":"https:\/\/bim-me-up.com\/en\/wp-json\/wp\/v2\/posts\/198642\/revisions"}],"predecessor-version":[{"id":456095,"href":"https:\/\/bim-me-up.com\/en\/wp-json\/wp\/v2\/posts\/198642\/revisions\/456095"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bim-me-up.com\/en\/wp-json\/wp\/v2\/media\/198643"}],"wp:attachment":[{"href":"https:\/\/bim-me-up.com\/en\/wp-json\/wp\/v2\/media?parent=198642"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bim-me-up.com\/en\/wp-json\/wp\/v2\/categories?post=198642"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bim-me-up.com\/en\/wp-json\/wp\/v2\/tags?post=198642"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}