OK, it may be a minor feature to most, but I use formulas a LOT, and find these new functions pretty sweet.

I also posted this, and lots of other formulas to use in Revit, in this thread at the Revit Forum.

Values in formulas can be now rounded up or down. For example, when riser height is calculated, one needs the function “round” to find the appropriate value.

**ROUND(x)**

The round function returns a number rounded nearest to a whole number. It doesn’t take into consideration rounding direction (round up or down). If the number is (for example) from 24.5 to 24.9, the function rounds it to 25. If it is from 23.1 to 23.4, the function rounds it to 23.

Examples:

round ( 23.4) = 23

Round ( 23.5) = 24

Round ( 23.6) = 24

Round (-23.4) = -23

Round (-23.5) = -23

Round (-23.6) = -24

Syntax

The syntax for the round function is: round( number)

number is the number to round.

**ROUNDUP(x)**

“x” is a unitless value that should return the largest integral value less than or equal to x.

For example:

roundup ( 23.0) = 23

roundup ( 23.5) = 23

roundup ( 23.9) = 23

roundup (-23.0) = -23

roundup (-23.5) = -24

roundup (-23.9) = -24

The syntax for the roundup function is: roundup (number)

number is the number to round up.

**ROUNDDOWN(x)**

“x” is a unitless value that should return the smallest integral value greater than or equal to x.

For example:

rounddown ( 23.0) = 23

rounddown ( 23.5) = 24

rounddown ( 23.9) = 24

rounddown (-23.0) = -23

rounddown (-23.5) = -23

rounddown (-23.9) = -23

The syntax for the rounddown function is: rounddown (number)

number is the number to round down.

Note that when numbers such as 23.5 are rounded, they can result in either 23 or 24. To produce a stable result, for all the .5 cases, we round to the larger integer. That means that 23.5 is rounded to 24, while -23.5 to -23

Great Article

ReplyDeleteJava Online Course | Java EE Training

Java Training Institutes in Chennai | java j2ee training institutes in chennai | Java Training in Chennai | J2EE Training in Chennai | Java Course in Chennai

Java Interview Questions | Java Training Institutes | IT Technical Articles

Nice post I have been looking for AutoCAD training and all to be fine there are some autodesk authorised training center that may help in find the best training center.

ReplyDelete

ReplyDeleteThank you for sharing such great information !

big data classroom training

hadoop ónlinÉ training

free big data bootcamp

hadoop big data videos

Big data QA Tester training

Big data Analyst training

ReplyDeleteThank you for sharing such great information !

big data classroom training

hadoop ónlinÉ training

free big data bootcamp

hadoop big data videos

Big data QA Tester training

Big data Analyst training

ReplyDeleteThank you for sharing such great information !

big data classroom training

hadoop ónlinÉ training

free big data bootcamp

hadoop big data videos

Big data QA Tester training

Big data Analyst training

My Arcus offer java training with 100% placement. Our java training course that includes fundamentals and advance java training program with high priority jobs. java j2ee training with placement having more exposure in most of the industry nowadays in depth manner of java

ReplyDeletejava training in chennai