It is not necessary to type
an equal sign (=) before the equation.
The equal sign is inserted automatically.You can insert equations or formulas into a cell of any annotation table (except Excel-based bills of materials).
To insert an equation or formula in a table:
In the Cell PropertyManager, under Text Format, click Equation.
In the dialog box, enter the equation and select from the following:
It is not necessary to type
an equal sign (=) before the equation.
The equal sign is inserted automatically.
Custom properties. Displays custom properties for the items in the drawing. Double-click to select an item. The item appears in single backward quotation marks in the equation display (for example, `SW-Subject`).
You can perform mathematical
expressions with text strings if the custom property has a numerical value.
Allow extra characters in column and custom property value. If selected before you double-click an item in Custom properties, this option inserts a # symbol in front of the item when displayed in the equation display (for example, #`SW-Current Sheet`). When the # symbol is present, non-numeric text is ignored from the calculation. If this option is cleared and an item includes non-numeric characters, the value appears as 0.0.
IF. Inserts the syntax for an IF function within the equation. An IF function returns one value if the condition specified is true and another value if the condition is false. The conditions are delimited by semi-colons, where the format is: IF(logical_test; value_if_true; value_if_false).
For example:
Equation: IF(`SW-Total Sheets`<>""; `SW-Total Sheets`; "-")
Result: SW-Total Sheets value (if not empty) or "-".
{ }. Inserts curly brackets for the equation.
SUM. Inserts the syntax for a SUM function within the equation. A SUM function adds several items together. For example, SUM(A1:A5) gives the sum of the values from cells A1 through A5.
More functions. Inserts the syntax for other functions such as AVERAGE, COUNT, MAX, and MIN. For example, AVERAGE(A1:A3) gives the average of the values from cells A1 through A3.
The SUM,
AVERAGE, COUNT,
MAX, and MIN
functions use cell numbers only. They cannot use custom property text.
Decimal places. Defines the number of decimal places for the resulting value of the equation.
Click OK.