I have been using this excel formula generator for a while now and it has come in very handy from time to time. It originated from Chris Price (Cadway and Xrev) and was distributed at an RTC (Revit Technology Conference) a while ago.
When you are using formulas in you families and you have to produce an ‘if’ statement with many nested conditions then having to type all the information can take a while. This simple excel document can shortcut all of the manual input.
All you have to do is cut and paste the resulting formula (in Column E), into your formula parameter in your family…..
You can alter or build on the information in the excel table as required.