Millworker Help Printable version
Help / Tools

Functions and formulas

Part Assembly

IF/THEN formulas and your own functions on parameters, worked out by Millworker.

Where

Formulas

A formula can do what Inventor's expressions cannot:

ConditionsIF Width > 30 THEN 3 ELSE 2, ELSE IF chains, if(Width < 25, 1, 2)
Comparisons and logic= <> < <= > >=, AND OR NOT
Arithmetic+ - * / ^ %
Functionsmin max abs round (round(x, 2)) floor ceil sqrt sin cos tan (degrees) pow sign clamp
NamesThe document's parameters and your own functions.

Lengths are in the document's length unit and angles in degrees: Width is 30 in a 30″ part. A number can carry its own unit (254 mm). The parameter's value becomes the result and is worked out again a moment after any change to the document (one undo step; Recalculate does it now).

The value cell of a formula parameter is pale yellow. A formula that cannot be worked out is red, with why on its tip. The formula is kept on the parameter, so it stays with the document.

Screenshot placeholder images/formulas-column.png 1200 × 420 px Parameter Manager cropped to a few rows: ShelfQty with formula ShelfCount(Height) and a pale yellow value; one bad formula in red with its tooltip showing.
Formulas in the ƒx Formula column.
Formulas in the ƒx Formula column.

Your own functions

ƒx Functions… lists your functions, one row each: Name, Arguments, Formula and Description.

Example: ShelfCount (h) = IF h > 30 THEN 3 ELSE IF h > 20 THEN 2 ELSE 1, then the formula ShelfCount(Height).

Screenshot placeholder images/formulas-functions.png 1100 × 600 px ƒx Functions… window with ShelfCount and two other functions, the Try a formula box at the bottom with a result.
The functions window.
The functions window.