Creating conditional plug cells
You can create conditional plug cells if necessary. A conditional plug cell allows you to direct the difference between the two compared cells to multiple locations based on certain conditions. For example, if the difference is supposed to plug to accounts payable and no balance exists for accounts payable, the difference should go to another cell.
Procedure
- Click Add Cell. The name field for Cell C (the first field to the right of the radio button) becomes a drop-down, enabling you to select the plug cell from a list of defined plug cells, and an entry named new cell is added to this drop-down.
- Select new cell from the Cell C name drop-down.
- Click on a cell in the financial statements. The name of this cell is added to the Cell C name drop-down, and its description is included in the Cell C description field. This description will appear whenever this cell is selected from the drop-down.
- In the Plug condition field, type a condition to be evaluated. If the condition is true, this plug cell is passed over, and the plug condition for the next plug cell in the drop-down is evaluated. If the condition is false, this cell becomes the plug cell, and the difference between Cell A and Cell B is placed in this cell.
- Repeat these steps to create as many plug cells as you need.
- To remove a plug cell from the list, select it from the Cell C name drop-down and click Delete Cell.
Results
The conditional plug cell is created.
