• Values
  • Values
  • Legacy Values
  • To flip a cell value
  • To flip the bank balance
  • To switch the sign of a cell value

Flipping The Bank Balance

You will create two cells, one in the Assets section and one in the Liabilities section of the Balance Sheet. Then you will link these to the bank balance in the Trial Balance database. Assign both to "Negative becomes positive" and then flip the one in the Liabilities section.

1. Create a numeric cell in the Assets section of the Balance Sheet.
2. Click the Numeric tab in the Edit Cell dialog and select Negative becomes zero.
3. Click the General tab and enter a function linking to the bank balance in the Working Trial Balance (AM database).

4. Click OK.

5. Now create a numeric cell in the Liabilities section of the Balance Sheet.
6. To display the bank balance only if it is a credit:
   1. Click the Numeric tab and select Negative becomes zero.
   2. Under Calculation Properties, check the Flip Sign of Value box.
7. Click the General tab and enter a function linking to the bank balance in the Working Trial Balance (AM database).

8. Click OK.

The bank balance will display on the Assets side of the Balance Sheet only if the balance is positive. Alternately, if the bank balance is negative, it will display only on the Liabilities side of the Balance Sheet. The result is a flipping of the bank balance to ensure that it appears on the correct side of the Balance Sheet.

Related Topics

• About cell calculations