Formula Tricks

[clog boy]

I learned a very neat trick yesterday. You ever get 'inconsistent units' as result from a formula? For instance if you wanted to multiply moolah with area with integer with bingzoombang? There's one real obvious way to make everything unitless.

Example: =(Cost/1$)*(Area/1m²)*(bingzoombang/1bzb)

Or in other words, just divide the parameter with one instance of it's own unit. The order in which you process everything will make a difference too, but if you really hit this one snag and don't have time or a superbly overflowing know-how to solve it 'the right way', make it unitless and you'll get the right result every darn time.

1320mm/1mm = 1320. 8ft/1ft = 8. 1320 sq.ft/1sq.ft = 1320. $1,836,249/$1 = 1,836,249. Easy like that. It's not even a workaround, it's the right mathematical way to go around with processing numbers.


Now suppose you have a formula and only want one parameter to be interactive. Height = Length / 2 will make both interactive.
You can add a dummy parameter, but that's just clutter. My way: Height = if(Length>0, Length/2, 0)

[truevis]

This does what a lookup table does (without requiring RME):

Tap Thickness = if(Tap Diameter < 0' 1 1/4", 0' 1 1/16", if(Tap Diameter < 0' 2", 0' 1 5/16", if(Tap Diameter < 0' 2 1/2", 0' 1 5/8", if(Tap Diameter < 0' 3", 0' 1 5/8", if(Tap Diameter < 0' 3 1/2", 0' 1 3/4", if(Tap Diameter < 0' 5", 0' 2 1/4", 0' 3 11/16"))))))

[WYSIWYG-BIM]

Please help me de-bug my formula. IF ( H_LEFT > H_RIGHT ) H_LEFT , H_RIGHT ) and I am getting a "VERIaBLE NOT EXPECTED" error. I have two fields with lengths in them and i want to do a calculated formula in my scedule that says whichever of the two is the higher value than put it in this new cell. I can write it in excel but it's now working right in Revit.

Thanks!

[CADastrophe]

The only issue with this is that the IF statement is closed after the conditional statement, which would produce an error. That first closed parenthesis should simply be a comma, instead.

IF ( H_LEFT > H_RIGHT , H_LEFT , H_RIGHT )