Plug Cell Setup Command - Rounding Dialog
Rounding relations may have multiple plug cells that allow the difference to be plugged into different cells depending upon the plug's value.
When values are present in cells 1 and 2 and the rounding relation is enabled, the relation searches for the first plug cell whose condition is not true based on the value of the difference. If all of the plug cells' conditions are met, then the difference is not inserted anywhere.
Plug Cells
The table displays existing plug cells for the difference cells chosen in the Rounding dialog.
Add
Click to add a new plug cell and condition for the difference cells. A new line is added to the table and the Plug Cell properties fields are readied to fill in.
Remove
To remove an existing plug cell, select it in the list and then click Remove.
Plug Cell Properties
Cell
Type or select a cell to use as the plug cell.
Click the Pick Cell button to launch the Cell Picker dialog.
Click the Go to Cell button to highlight the cell name.
Plug Condition
Enter a plug condition for the cell chosen. Click the button to access the Calculation Editor.
The Plug Condition is the condition that makes this cell get skipped as the plug cell. That is, if the condition is evaluated to be true, the difference is not plugged here and another plug cell is searched for. If the condition is evaluated to be false, the value of the difference between cells 1 and 2 goes in this cell.
Notes
- Be careful with the order in which you add the plug cells. If two or more plug cells are evaluated to be 0 or false, the plug value goes in the first cell the relation finds and then stops looking. This may not be the correct cell to use for the plug.
- Use the up
and down
arrows to change the order of the plug cells: click a plug cell and then click an arrow to move the plug cell up or down.