Using Formula Editor

Using Formula Editor

The Formula Editor is a handy tool for reading and writing formulas. To access the Formula Editor, select a cell and press the F2 key.


  1. Large Text – Checking the box will make all the text larger.
  2. Find and Replace – Launches the find and replace.
  3. Name – Allows you to select a defined name from the Global Variables, Local Variables, Subassembly Variables, or AutoCAD Blocks.
  4. Function – Allows you to write a formula by selecting the type of function you wish to use. By highlighting a function within a formula, clicking the insert function button will break down the function allowing you to read and comprehend the formula easily.
  5. Apply Formula – Closes the formula editor and applies the formula.

When using the Function tool to write a formula, the following message will appear. Click OK to close the message.


Once the message has been closed, the Function Arguments window will be displayed.



This interface allows you to write formulas without having to worry about syntax. To start, select a function from the Function List, and then populate the required fields for the function. When all the fields have been entered, the Insert button will become active.

To use the Function tool to breakdown a formula, you must highlight the function before clicking the Function button.



See the knowledge base article Formulas to learn more.


    • Related Articles

    • Understanding the Edit Design Data Interface

      The Edit Design Data interface is a spreadsheet editor, similar to Microsoft Excel.  The interface includes tools located at the top of the window. Below the tool icons is a drop-down list of defined names that can be used to locate the cell’s ...

    • Formulas

      Formulas Formulas are used extensively throughout Microvellum. Formulas drive the library products and are used to help automate procedures. Formula reading and writing can be a challenge. Luckily, reading and writing formulas doesn’t require a ...

    • Accessing the Edit Design Data Interface

      Accessing the Edit Design Data InterfaceThere are several ways to access the Edit Design Data interface: When drawing products (Draw > Draw Products), you can right-click in the product list, expand the “More” list at the bottom of the menu, and ...

    • Understanding the OFFSETPOLYLINE Spreadsheet Function

      The OFFSETPOLYLINE Spreadsheet Function allows for vector points to be entered, from a polyline token, for example, and the function then returns the vector coordinates offset by the desired amount. The OFFSETPOLYLINE function is formatted as such: ...

    • Working Within the Subassemblies Tab

      Working Within the Subassemblies Tab The Subassemblies tab is where the subassemblies for the product are located. The majority of library products contain subassemblies. Subassemblies are products within products. Subassemblies can be added manually ...

    • Recent Articles

    • Toolbox Release Notes | Build 25.1.0114.641

      The following release notes apply to Toolbox build 25.1.0114.641. UI Fixes Several issues were reported and discovered within the OEM 2025 user interface. The following issues have been resolved: Fig. 1: Excess commands on the tool strip being ...

    • Toolbox Release Notes | Build 25.1.102.641

      The following release notes apply to Toolbox build 25.1.102.641 Toolbox OEM 2025 Work smarter, and faster with Toolbox 2025 (OEM). With an OEM Subscription, you’ll gain access to the latest toolsets and innovative features of Toolbox 2025. ...

    • What’s New in Toolbox 2025 (OEM)

      Work smarter, faster with Toolbox 2025 (OEM). With an OEM Subscription, you’ll gain access to the latest toolsets and innovative features of Toolbox 2025. Improvements Toolbox UI Overhaul OEM 2025 introduces several updates to the appearance and ...

    • Toolbox Release Notes | Build 24.1.1206.641

      The following release notes apply to Toolbox build 24.1.1206.641 MV Server Nesting Fix There was a reported issue occurring when users attempted to remotely process work orders using a nesting station on MV Server. When attempting to process the work ...

    • Microvellum Foundation Library Release Notes | Build 24.1127

      The following release notes apply to Microvellum Foundation Library build 24.1127. Additions Added a new Soffit product to the Upper Cabinet Accessories category. Added the Top Filler (Ceiling Scribe) option to Upper and Tall cabinets. (Corner ...