Monday 6 January 2014

Nested If statement generator

A spreadsheet I put together to speed up the annoying process of creating nested if statements in Revit formulas. I only did 27 levels of nesting, this could be expanded easily.

Download Current Live version - File > "download as" can be used below
(Note: Operators such as = will need to be cleaned up in excel as the show up as '=)

Download Example version

Example Version:

This example uses the "less than" operator to adjust a value based on the "Width" parameter, if it is below 500 the value is 50, if between 500 and 700 it is 75 and so on...



No comments:

Post a Comment