Round up the Beam length with overhang (using the Property created in Example 5), so that the Beam lengths conform to a standard beam size (length divisible by 30 cm).
–Use the MROUNDUP function for this purpose.
See Round Up to Multiple [MROUNDUP] for information on this function’s arguments and data types.
Relevant topics
Round [ROUND]
Rounds a number to a specified number of digits.
Syntax
ROUND (Number, NumberOfDigits)
Note: The required separator (comma or ...
Example 5: Calculate a Length and Add Overhang
Calculate required Beam length, taking into account the extra ledge length (20 cm) needed for each.
To do this, create a property that expands ...
Example 4: Calculate a Quantity and Round Up
Round up a calculated quantity to conform to standard material (e.g. brick) size
•Determine the number of bricks you need to order (by ...