Transaction Amounts Copied to DEBIT and CREDIT columns.

[billy60]

Hi,

On the Transactions sheet the Amounts column need to be separated into the Debit and Credit columns by Income or Expense category.

An exception was when there was a refund for a charge that I highlighted in rows 61 and 63.

The formulas seem to work but I get FALSE results when there isn't an assigned Income or Expense.

Are there other better formulas to avoid any errors like this?

Thank you for your help

[TMS]

This:

Please Login or Register  to view this content.

[billy60]

Thank you TMS.

[TMS]

You're welcome. Thanks for the rep.